Ask Your Question
0

multi-line spreadsheet headers [closed]

asked 2017-02-03 06:36:24 +0100

PaulG gravatar image

Running libreoffice 5.2.5.1 ... I'm trying to print a spreadsheet with 3 rows of header info that I want to print at the top of each page. I'm pretty sure that I've frozen the rows correctly, since when I page down thru the document the desired rows remain displayed on the screen. But when I go to print-preview, only two of the rows get displayed at the top of pages 2 and above. Any suggestions on how to get proper printing and on-screen display?

(I've installed libreoffice on a NetBSD-7.99.53 system, compiled from sources using NetBSD's pkgsrc...)

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by PaulG
close date 2017-02-03 23:52:06.034422

1 Answer

Sort by » oldest newest most voted
0

answered 2017-02-03 07:05:21 +0100

updated 2017-02-03 07:15:49 +0100

The row freeze (on-screen display feature) has nothing to do with print range. The printed range is defined in menu Format->Pring ranges (you may select required range and use the Define option of the above menu; what you specifically want is to define Rows to repeat in "Edit" submenu).

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2017-02-03 06:36:24 +0100

Seen: 101 times

Last updated: Feb 03 '17