Bug 159995 - LibreOffice Calc won't respect page settings for printing on macOS
Summary: LibreOffice Calc won't respect page settings for printing on macOS
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.0.3 release
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: QA:needsComment
Keywords:
Depends on:
Blocks:
 
Reported: 2024-03-02 11:08 UTC by M-Rick
Modified: 2024-03-17 03:14 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
LibreOffice Calc: Pages settings defined as A3 and no margins (1.72 MB, image/png)
2024-03-02 11:10 UTC, M-Rick
Details
LibreOffice Calc: settings aren't respected at all in macOS (577.19 KB, image/png)
2024-03-02 11:11 UTC, M-Rick
Details
Numbers: same table with same settings (869.88 KB, image/png)
2024-03-02 11:12 UTC, M-Rick
Details
Numbers: Page settings allows to set the paper size, orientation and settings are respected. (881.52 KB, image/png)
2024-03-02 11:13 UTC, M-Rick
Details
Numbers: print menu keeping the print settings (1.35 MB, image/png)
2024-03-02 11:14 UTC, M-Rick
Details
Numbers: result in Preview as expected in A3 and no margins (618.29 KB, image/png)
2024-03-02 11:15 UTC, M-Rick
Details
Windows: works as expected (59.56 KB, image/png)
2024-03-02 11:17 UTC, M-Rick
Details
Linux: works as expected (89.29 KB, image/png)
2024-03-02 11:17 UTC, M-Rick
Details

Note You need to log in before you can comment on or make changes to this bug.
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