Ask Your Question

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

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

johkra 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 close merge delete

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 1,230 times

Last updated: Oct 11 '15