Open xslx file from a correspondent. Print to physical printer, the print dialog preview looks fine, letter size 8.5x11. Print to Microsoft Print to PDF, the page size in print dialog defaults to 4.13x9.25. What?? More pertinently, how to persuade LO to default to the same page size as document?
This for sure does not happen with other apps, or with LO Write.
thankyou
P.S. Why required field “category” is not labeled “language,” I know not.
Why not File > Export to pdf? It will result in a smaller pdf at the expected size.
Probably, the default paper size for Microsoft Print to PDF is set to that size. The last Windows update reset it for me from A4 to Letter.
Click Start Menu > Settings > Bluetooth & Devices > Printers & Scanners > Microsoft Print to PDF > Printing preferences, click the Advanced button and set Paper Size to Letter. OK out
If you saved the document with those settings, then you might need to click File > Printer Settings > Microsoft Print to PDF > Properties and set Paper Size to Letter. OK out
Thanks for reply. It turns out that both settings you described, already were set to letter.
But as an example of wacko aspects of technology, after simply viewing those 2 settings, without making any change, now BOTH my Canon printer & the virtual MSFT print to PDF, default to some useless Japanese envelope size. Change it to Letter, OK & out, but setting sometimes doesn’t stick. Seemingly random.
BTW I use Microsoft Print to PDF because it works for several other apps, but might be too unreliable in Calc. Maybe I can delete the other paper sizes from my PC.
What version of LibreOffice? Click Help - About LibreOffice to bring up the dialogue, then click the icon with tooltip Copy details to clipboard just after Version information.
Paste those details into a comment.
Have you restarted your computer recently? Click Start menu - Power - Restart (not shut down as that defaults to hibernate).
[Edit 2025-12-09T11:00:00Z ]
Maybe Bug 168759 - Printing: changing printer changes page size
Feel free to add yourself to CC for the bug, at the moment it is in limbo, confirmed but unconfirmed
Re bug report, upgrade to 25.8.3.2 to solve issue
Hello again
Version: 25.8.3.2 (X86_64)
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
CPU threads: 10; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
PC was restarted by MSFT (without announcement thank you MSFT) on 12/9. Just now confirmed that the LO Calc behavior is still wacky.
I cannot replicate in 28.5.3.2, but that shouldn’t stop you making a bug report (and linking the bug report back here). See How to Report Bugs in LibreOffice - The Document Foundation Wiki
Note that there is a similar (but not the same) issue, Paper size changes unexpectedly
The second Tuesday of the month is Update Tuesday for Windows. As soon as I see that my computer has installed the update, I immediately close everything and restart Windows. Installing the updates can leave the computer in an uncertain state and peculiar things can happen, so even when doing something urgent, it is quickest to restart as soon as possible.
I am having the exact same issue, have submitted bug tdf#170555
I just tried updating to version 25.8.4 and the problem remains, I am stuck with Japanese Envelope #4 as my page size.
Is there a reason why you print to PDF rather than File - Export as - PDF? Exporting generally results in a smaller file size but with links and cross-references still working.
Yes, because with export to pdf I have never managed to select a group of cells and get it to create a single page pdf of the correct size and orientation with just those cells on it.
It is perhaps possible to do and just down to a non intuitive set of menus, but that is the end result.
Up until I recently updated LO I had no problems doing that using print to pdf.
I will try and demonstrate why I don’t use export over the next few emails (I can only send one attachment per email
An example below using Export as pdf
The spreadsheet selection started with
I will try and demonstrate why I don’t use export over the next few emails (I can only send one attachment per email
An example below using Export as pdf
The resultant pdf output
list test.pdf (118 KB)
@julianm To export to PDF
- Before you export, click Format > Page Style. In the dialogue
- Click Page tab and set Orientation to Landscape
- Click Sheet tab. Under Scale, in Scaling mode, set to Shrink range(s) on number of pages
- Set Number of Pages to 1 or to desired number. OK. (you might find File > Print Preview helpful to determine the number of pages)
- Select the cells that you want to export
- Click File > Export as PDF. In the General tab, click Selection/Selected sheets. Export
[Edit]
When I print to Microsoft Print to PDF, the preview changes to Letter, so I change it back to A4, Landscape and OK. It then prints correctly to pdf, although 2 1/2 times the file size of Export as PDF
.
Version: 25.8.3.2 (X86_64)
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
CPU threads: 8; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: en-NZ (en_NZ); UI: en-GB
Calc: CL threaded
Well, I think I followed all your instructions fully which were all very useful to learn so thanks for that, but it still did not print only the selected cells on the sheet I was on. I ended up with a pdf that contained multiple pages, each containing part of every sheet that my worksheet has. Sure one of those sheets was the selected cells, but only as one page of a pdf book.
With the print to pdf option that used to work just fine I got the cells I had highlighted, and nothing but those cells.
It sounds as though you had a range of sheet tabs selected.
Click on one of the tabs to deselect the other sheets before making your selection of cells otherwise you will get that same selection for every sheet selected.
Tthanks, that seems to have solved my issue. Still leaves a weird page size on my print to pdf but hopefully that won’t cause me any problems now.