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.

  • (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. – Doktoro Reichard Oct 31 '13 at 19:52
  • In openoffice there is a function fit-to-page in the page preview. But it doesn't work? – Gigamegs Oct 31 '13 at 20:14
  • 1
    It's working, at least for me. Try to upload example .ods. What version of LibreOffice? You may look at bugzilla. – week Oct 31 '13 at 21:15
  • 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. – tohuwawohu Nov 1 '13 at 9:20
  • Was my answer helpful for you? – tohuwawohu Nov 14 '13 at 9:07

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.