Ask Your Question

How to set a print range..

asked 2019-09-16 14:27:37 +0200

Pete of Ebor gravatar image

Hi. I have a calc spreadsheet which I want to print. The table was designd to easily fit onto one sheet of A4 in landscape format. When I try to print it, I get the top 9 rows on one page and the bottom 27 rows on the next page. I have checked the margins.. The table fite well inside. I have tried clearing the print range - same result. I have tried defining the print range to just the whole table - same result. If I alter either the zoom factor on the sheet or the scaling factor in print preview I still get the same 9 row/27 row split over two pages. Is there something I am missing ?

Using LO (64bit) on Win 10

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-09-16 14:35:57 +0200

Opaque gravatar image

updated 2019-09-16 14:36:29 +0200


may be you missed to set option Scaling mode to Fit print range(s) on number of page to value 1. To do so:

Format -> Page -> Tab: Sheet an set according to screenshot:

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-09-16 14:27:37 +0200

Seen: 41 times

Last updated: Sep 16