Bug 161036 - XLSM to PDF export different to MS 365: does not show spreadsheet footer, does not fit contents on one page
Summary: XLSM to PDF export different to MS 365: does not show spreadsheet footer, doe...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Printing and PDF export (show other bugs)
Version:
(earliest affected)
6.0.0.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsDevAdvice
Depends on:
Blocks: PDF-Export XLSX-Header-Footer
  Show dependency tree / graph
 
Reported: 2024-05-11 07:36 UTC by nengxing_xu
Modified: 2024-05-27 03:53 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Comparison of correct and incorrect effects (157.00 KB, image/png)
2024-05-11 07:38 UTC, nengxing_xu 		Details
source excle file (461.17 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2024-05-11 07:39 UTC, nengxing_xu 		Details
source word file. (40.06 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2024-05-11 07:39 UTC, nengxing_xu 		Details
MS 365 PDF export (323.98 KB, application/pdf)
2024-05-27 03:06 UTC, Stéphane Guillou (stragu) 		Details
LO 24.8 alpha1+ PDF export (722.77 KB, application/pdf)
2024-05-27 03:07 UTC, Stéphane Guillou (stragu) 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description nengxing_xu 2024-05-11 07:36:47 UTC 
Description:
On Linux, there is a problem of content occlusion when using libreoffice for ofice2pdf

Actual Results:
there is a problem of content occlusion

Expected Results:
The content can be fully displayed


Reproducible: Always


User Profile Reset: Yes

Additional Info:
no more information
Comment 1 nengxing_xu 2024-05-11 07:38:43 UTC 
Created attachment 194081 [details]
Comparison of correct and incorrect effects
Comment 2 nengxing_xu 2024-05-11 07:39:21 UTC 
Created attachment 194082 [details]
source excle file
Comment 3 nengxing_xu 2024-05-11 07:39:40 UTC Comment hidden (off-topic)
Comment 4 Stéphane Guillou (stragu) 2024-05-27 03:05:19 UTC 
Thanks for the report.

Let's stick to the XLSM file in this report, as we have a screenshot for that. (Please open a different report for the DOCX.)

- I can reproduce that the footer is not visible in print preview and PDF, but a text selection shows the characters are there, very close to the bottom edge. I see that the Format > Page > Footer has a Spacing of 0, and a Height of 0.10 cm. If you increase the Height value, or alternatively use "AutoFit Height", the footer becomes visible in the export. So maybe "not a bug"?

- The table not fitting on one page: the visual aid shows that the printing goes beyond the page break. To fix it, one might want to:
  * change the page format to a bigger size, or reduce the margins, so the resulting PDF includes your whole table; or
  * resize the table so it fits on a single A4 page; or
  * use the "Whole Sheet Export" PDF option to have all the contents on one page.

...however, even though both issues can be worked around, the direct export to PDF is very different to what MS 365 exports (whole first table on first page; footer visible).

So maybe a import filter issue?

Reproduced in LO 6.0.0.3 and:

Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: ae798781ef4df7a1fdef13af0bc459bf4f6e7b4c
CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: CL threaded

See also bug 106539.
Comment 5 Stéphane Guillou (stragu) 2024-05-27 03:06:13 UTC 
Created attachment 194362 [details]
MS 365 PDF export
Comment 6 Stéphane Guillou (stragu) 2024-05-27 03:07:32 UTC 
Created attachment 194363 [details]
LO 24.8 alpha1+ PDF export