15

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.

Improve this question
10
  • (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, 2013 at 19:52
  • In openoffice there is a function fit-to-page in the page preview. But it doesn't work?
    – Micromega
    Oct 31, 2013 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, 2013 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, 2013 at 9:20
  • Was my answer helpful for you?
    – tohuwawohu
    Nov 14, 2013 at 9:07

1 Answer 1

Reset to default
26

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

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .