Bug 159995

Summary: LibreOffice Calc won't respect page settings for printing on macOS
Product: LibreOffice Reporter: M-Rick <m.rick.mac>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: UNCONFIRMED ---    
Severity: normal    
Priority: medium    
Version: 24.2.0.3 release   
Hardware: All   
OS: macOS (All)   
Whiteboard: QA:needsComment
Crash report or crash signature: Regression By:
Attachments: LibreOffice Calc: Pages settings defined as A3 and no margins
LibreOffice Calc: settings aren't respected at all in macOS
Numbers: same table with same settings
Numbers: Page settings allows to set the paper size, orientation and settings are respected.
Numbers: print menu keeping the print settings
Numbers: result in Preview as expected in A3 and no margins
Windows: works as expected
Linux: works as expected

Description M-Rick 2024-03-02 11:08:48 UTC
Description:
The LibreOffice Calc version of macOS has really bad respect of print settings.

If I want a page to be exported as PDF in A3 size using the build PDF printer in LibreOffice Calc in macOS, the page will always be resized to A4 waterer the settings are.
Plus, it adds a margin all around while the margins have been set to 0 everywhere. And it's impossible to set the page orientation, unlike Linux and Windows versions.
So I need to trick by using multiple columns. But LibreOffice will add a margin all around on both of them. This doesn't happen with Linux and Windows versions as well.
The PDF export will not respect print settings as it export the whole content as this and doesn't provide an option to remove blank pages…

It's a LibreOffice bug, since I tried exactly the same settings in macOS Numbers and it works perfectly. plus there is a global printing setting unavailable in LibreOffice.

Steps to Reproduce:
1. Create a Calc spreadsheet and set it up to A3 with 0 cm margins.
2. Go to print and set 2 pages per file and enable to fit to paper size.
3. Use the PDF menu to open in Preview or save as PDF.
4. Check the size, it's A4…

Actual Results:
Printed in A4 and add black space around datas.

Expected Results:
Should respect the settings and use a A3 size.
Shouldn't add black space around printed datas if margins are set to 0.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
The problem is old and available in all LibreOffice Mac versions even if I tagged the latest one.
Comment 1 M-Rick 2024-03-02 11:10:42 UTC
Created attachment 192902 [details]
LibreOffice Calc: Pages settings defined as A3 and no margins
Comment 2 M-Rick 2024-03-02 11:11:47 UTC
Created attachment 192903 [details]
LibreOffice Calc: settings aren't respected at all in macOS
Comment 3 M-Rick 2024-03-02 11:12:30 UTC
Created attachment 192904 [details]
Numbers: same table with same settings
Comment 4 M-Rick 2024-03-02 11:13:28 UTC
Created attachment 192905 [details]
Numbers: Page settings allows to set the paper size, orientation and settings are respected.
Comment 5 M-Rick 2024-03-02 11:14:13 UTC
Created attachment 192906 [details]
Numbers: print menu keeping the print settings
Comment 6 M-Rick 2024-03-02 11:15:00 UTC
Created attachment 192907 [details]
Numbers: result in Preview as expected in A3 and no margins
Comment 7 M-Rick 2024-03-02 11:17:24 UTC
Created attachment 192908 [details]
Windows: works as expected
Comment 8 M-Rick 2024-03-02 11:17:46 UTC
Created attachment 192909 [details]
Linux: works as expected