We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

multi-line spreadsheet headers [closed]

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

PaulG gravatar image

updated 2020-08-02 12:38:40 +0200

Alex Kemp gravatar image

Running libreoffice ... 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

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

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

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


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

Seen: 139 times

Last updated: Feb 03 '17