Ask Your Question

How to export pdf from calc with multiple sheets and each sheet in one page?

asked 2016-03-12 05:13:05 +0100

chu gravatar image

Hi , I have a xls file with four sheets in one file, and I want to export it to the pdf.

I hope the result pdf file have four pages and Each sheet scaled its content into one page.

I have followed the another question's answer to set the option in Format->Page->Sheet->Scale->Scale model : "Fit print range on number of pages" to 1.

But only the first sheet has been scaled its content into one page in the result pdf ,other sheets didn't.

I have tried many times and got the same result.

Is it a bug? or I have missed something?

Please do me a favor ,Thanks a lot!


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-03-12 11:46:44 +0100

JohnSUN gravatar image

Just set Tools - Options - LibreOffice Calc - Print - Sheets - Print only selected sheets to OFF

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-03-12 05:13:05 +0100

Seen: 2,650 times

Last updated: Mar 12 '16