Bug 165537 - Export PDF does not replicate document it is exporting
Summary: Export PDF does not replicate document it is exporting
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL: https://ask.libreoffice.org/t/pdf-exp...
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-03-02 18:43 UTC by becripps
Modified: 2025-05-11 09:18 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
A Sample Calc file (420.09 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-03-02 18:44 UTC, becripps
Details
A Sample PDF File (344.43 KB, application/pdf)
2025-03-02 18:46 UTC, becripps
Details
Sample PDF created from Calc sample (402.44 KB, application/pdf)
2025-03-02 21:47 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description becripps 2025-03-02 18:43:35 UTC
Description:
When using the Export PDF functionality in LibreOffice Calc, the document often has errors, usually with rogue text being added or some text not being displayed.  This has persisted across several versions of the product - some exports work fine, others are very close to correct... sometimes there is text all over the place and it is completely wrong.  This happens whether using the export through the File menu or the shortcut button on the toolbar.

Steps to Reproduce:
1.  Make a calc file.
2.  Export to PDF.
3.

Actual Results:
Just have a calc file and export it to PDF.  

Expected Results:
I would expect that ALL of the text in the calc would appear in the document.


Reproducible: Sometimes


User Profile Reset: Yes

Additional Info:
I will say that I do NOT know if this happens with all fonts or just certain ones - it seems to effect my documents in cells that are using the Liberation Serif.  Text that is there in the calc is not there in the pdf.

There is a TON of documentation on this with files in this thread:

https://ask.libreoffice.org/t/pdf-export-does-not-show-italicized-text/115664/4
Comment 1 becripps 2025-03-02 18:44:25 UTC
Created attachment 199562 [details]
A Sample Calc file

Here is a sample calc file.
Comment 2 becripps 2025-03-02 18:46:05 UTC
Created attachment 199564 [details]
A Sample PDF File

Here is a sample PDF exported on my machine from the calc file attached here.

Notice the difference in the box at the bottom of each side of calc labeled "Notes & Superlatives" - there is text missing in the PDF compared to the Calc.
Comment 3 m_a_riosv 2025-03-02 21:47:18 UTC
Created attachment 199569 [details]
Sample PDF created from Calc sample

I don't see what is missing.
Comment 4 becripps 2025-03-02 23:41:45 UTC
(In reply to m_a_riosv from comment #3)
> Created attachment 199569 [details]
> Sample PDF created from Calc sample
> 
> I don't see what is missing.

I don't see anything missing on 'Sample PDF created from Calc sample'.  

There are things missing in the 'A Sample PDF file'.

As I mentioned in the report, it is not a bug that happens 100% of the time - I would estimate roughly 50% of the time between two different work stations (at home and my work laptop - both Windows 11).
Comment 5 m_a_riosv 2025-03-03 22:48:09 UTC
Verify if you have installed the fonts of the missing text.
Comment 6 becripps 2025-03-04 01:32:07 UTC
I can verify this.  You can see the font in use throughout the document.

It was also suggested in the thread I linked as well as a possible solution.  Everything I tried is in there (and I tried a LOOOOOT of stuff).
Comment 7 raal 2025-04-02 16:04:30 UTC
Tested with Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 2dd493c86e532eea636b1ca8aed35fb1214eb750
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded
and cannot reproduce the bug. I did 4 exports and in every export the export was correct  - text in section Notes & Superlatives".
Comment 8 becripps 2025-04-02 16:50:50 UTC
(In reply to raal from comment #7)
> Tested with Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
> Build ID: 2dd493c86e532eea636b1ca8aed35fb1214eb750
> CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
> Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
> Calc: threaded
> and cannot reproduce the bug. I did 4 exports and in every export the export
> was correct  - text in section Notes & Superlatives".

Let me know if you need any other information.  It was still happening as of March 9, but as I'm out of basketball season I'm no longer working with those documents on a daily basis.