Ask Your Question

Calc - fit page width to number of pages but not height [closed]

asked 2015-10-08 09:41:11 +0200

johkra gravatar image

updated 2020-09-24 16:17:52 +0200

Alex Kemp gravatar image

Hi folks, there are different possibilites to handle the page layout in calc when printing. One of them is "fit to width/height". (Format/Page/Table)

Then one can input the number of pages in width and height.

My question: "Is it possible to adjust the number of pages in width - but not in height". Let's say: I don't care about the number of pages - but the content should not exceed the width of one page.

(In Excel you fill in "1" for width and leave on auto in height.) Cheers Johkra

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-26 15:05:19.154434

1 Answer

Sort by » oldest newest most voted

answered 2015-10-11 15:40:45 +0200

pierre-yves samyn gravatar image


Yes, it is possible... If you wish to only limit the width to 1 (e.g.) page must:

  • set Width in pages: 1
  • set Height in pages: a large number

Check Tools -> Options -> LibreOffice Calc -> Print -> Always apply manual breaks to be able to control page breaks by inserting page breaks


edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-10-08 09:41:11 +0200

Seen: 1,651 times

Last updated: Oct 11 '15