How to export pdf from a calc sheet and divide into multiple pages?

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.

On the Page Style you set With and Hight and then do export in PDF.

image description

I did this but it seems it only works after a reboot?

Download and install Primo PDF . It will be like a local printer once installed. Now just print your document thru PrimoPDF printer.