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

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!

Chu

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