How to scale a long LibreOffice Calc sheet to fit on two pages when exporting to PDF?

pdf spreadsheet openoffice-calc libreoffice-calc

26,829

You can't use the page preview options to scale the PDF output. Output scaling has to be done using the Sheet properties in the Page Style dialogue (Select the Menu Format -> Page... -> Sheet Tab).

There, you have different options to make the Calc output fit to a certain number of pages. In the following screenshot, the Scale options are highlighted, especially the Scaling mode ComboBox:

enter image description here

To scale the PDF output to two pages, just select the third option (Fit print range(s) on number of pages) from the Scaling Mode ComboBox and set the page number to 2. This should give a PDF output scaled to two pages:

enter image description here

26,829

Author by

Micromega

Professional CMS TYPO3 and Full Stack developer. If my answer is helpful please consider to donate: eth:0x6a0c4dda92ace3ec82fb4a2810091fd17539edb6 Fashionreps WatchExchange phpclasses Jsclasses Codeplex Github I am nerdier than 44% of all people. Are you a nerd? Click here to take the Nerd Test, get nerdy images and jokes, and write on the nerd forum! #SOreadytohelp

Updated on September 18, 2022

Comments

Micromega over 1 year

I have Libreoffice and I want to export a long calc sheet to a pdf document with the fit-to-page function from the page preview in the file menu but it doesn't seems to work. I want to fit my sheet up to 2 pages because it's unreadable otherwise. When I export the sheet it gives only one page and the sheet is unreadable.
- Doktoro Reichard over 10 years
  
  (knowing it isn't what you asked) in Excel, I would configure the page settings and probably preview the pages before exporting. Maybe something similar exists.
- Micromega over 10 years
  
  In openoffice there is a function fit-to-page in the page preview. But it doesn't work?
- cyberha4 over 10 years
  
  Could you please describe step-by-step what did you try. There are different fit-to-x options that may affect only the page display, not the print layout, and different LibreOffice version which offer different features.
- cyberha4 over 10 years
  
  Was my answer helpful for you?
- Micromega over 10 years
  
  @tohuwawohu:No,what is the sheet tab? AFAIK my question is very accurate. BTW. I use Linux version.
- cyberha4 over 10 years
  
  Linux of Windows doesn't differ in this point. Regarding the Sheet tab, i've highlighted the dropdown where you can select the scaling mode. In your case, select the third option (Fit print range(s) on number of pages) and set the page number to 2. This should give a PDF output scaled to two pages. I've emended my answer.
- cyberha4 over 10 years
  
  If there's still an issue with the answer (point missing, not clearly explained), please feel free to add a comment.
- Micromega over 10 years
  
  Thank you. It works but only after a reboot.
- Ciro Santilli Путлер Капут 六四事 about 8 years
  
  stackoverflow.com/questions/19940236/…