Bug 105573 - PDF Export with EMF images moves and distorts images
Summary: PDF Export with EMF images moves and distorts images
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Printing and PDF export (show other bugs)
Version:
(earliest affected)
5.2.3.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:emf
Depends on:
Blocks: PDF-Export EMF-WMF
  Show dependency treegraph
 
Reported: 2017-01-27 17:11 UTC by Rex
Modified: 2022-07-06 14:20 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
xlsx file created on desktop computer (146.69 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-01-27 17:12 UTC, Rex
Details
xlsx file created on laptop computer (112.55 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-01-27 17:13 UTC, Rex
Details
pdf export from libre office (1.15 MB, application/pdf)
2017-01-27 17:14 UTC, Rex
Details
pdf printout from libre office (1.46 MB, application/pdf)
2017-01-27 17:15 UTC, Rex
Details
pdf export from excel for comparison (189.06 KB, application/pdf)
2017-01-27 17:16 UTC, Rex
Details
pdf printout from excel for comparison (167.24 KB, application/pdf)
2017-01-27 17:16 UTC, Rex
Details
pdf export from libre office on laptop (276.55 KB, application/pdf)
2017-01-27 17:17 UTC, Rex
Details
pdf printout from libre office on laptop (1.75 MB, application/pdf)
2017-01-27 17:18 UTC, Rex
Details
Screenshot of sheet LML... on desktop libre office, notice missing lines (101.87 KB, image/png)
2017-02-07 15:04 UTC, Rex
Details
Screenshot of sheet LML... on desktop excel (122.57 KB, image/png)
2017-02-07 15:06 UTC, Rex
Details
Screenshot of sheet LML... on laptop libre office (96.30 KB, image/png)
2017-02-07 15:07 UTC, Rex
Details
Screenshot of sheet LML... on laptop excel (71.25 KB, image/png)
2017-02-07 15:08 UTC, Rex
Details
PNG - Screenshot of page preview of most jumbled page when printed/exported (117.83 KB, image/png)
2018-05-15 08:46 UTC, Rex
Details
pdf export from libre office 6.0.3.2 (159.36 KB, application/pdf)
2018-05-15 08:47 UTC, Rex
Details
scan of laser printout - all tables - from page preview in libre office 6.0.3.2 (2.05 MB, application/pdf)
2018-05-15 08:49 UTC, Rex
Details
scan of laser printout - current table - from page preview in libre office 6.0.3.2 (763.80 KB, application/pdf)
2018-05-15 08:51 UTC, Rex
Details
PDF export on Libre Office Calc 7.0.5.2 (113.94 KB, application/pdf)
2021-05-12 08:49 UTC, Rex
Details
PDF export on Libre Office Calc 7.1.3.2 (115.06 KB, application/pdf)
2021-05-12 09:16 UTC, Rex
Details
PDF export from version 7.3.4.2 (109.05 KB, application/pdf)
2022-07-06 14:20 UTC, Rex
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Rex 2017-01-27 17:11:46 UTC
Description:
An XLSX-File created in a CAD-Program (without use of Excel, LibreOffice or OpenOffice) is opened by LibreOffice and a PDF Export (or printout) for further propagation is made. 
Depending on computer contents of spreadsheet look acceptable (rexw10lap) or lines are missing (rexw10) from EMF images. 
PDF export looks catastrophic. Images are moved nearly off page, sometimes text is missing, many lines are missing.
Also simple attempt to print to PDF (using Soda PDF) delivers unsatisfactory results.

To ensure reproducibility used two separate computers, both with Windows 10, same CAD drawing in STRAKON (CAD-Program), same XLSX-settings, LibreOffice 5.2.3.3 and Soda PDF. Also for comparison used PDF exports and printouts from OpenOffice and Excel.

Steps to Reproduce:
1. Open attatched bug17598_rexw10lap.xlsx
2. Export to PDF
3. Print using a PDF printer or any other printer

Actual Results:  
see PDF attatchments

Expected Results:
create PDF files similar to what is seen in LibreOffice spreadsheet on screen


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:50.0) Gecko/20100101 Firefox/50.0
Comment 1 Rex 2017-01-27 17:12:56 UTC
Created attachment 130722 [details]
xlsx file created on desktop computer
Comment 2 Rex 2017-01-27 17:13:50 UTC
Created attachment 130723 [details]
xlsx file created on laptop computer
Comment 3 Rex 2017-01-27 17:14:33 UTC
Created attachment 130724 [details]
pdf export from libre office
Comment 4 Rex 2017-01-27 17:15:17 UTC
Created attachment 130725 [details]
pdf printout from libre office
Comment 5 Rex 2017-01-27 17:16:12 UTC
Created attachment 130726 [details]
pdf export from excel for comparison
Comment 6 Rex 2017-01-27 17:16:56 UTC
Created attachment 130727 [details]
pdf printout from excel for comparison
Comment 7 Rex 2017-01-27 17:17:37 UTC
Created attachment 130728 [details]
pdf export from libre office on laptop
Comment 8 Rex 2017-01-27 17:18:26 UTC
Created attachment 130729 [details]
pdf printout from libre office on laptop
Comment 9 Bartosz 2017-02-01 11:00:44 UTC
This issue is not related to .xlsx as it is reproducible for .ods
Comment 10 Rex 2017-02-07 15:04:46 UTC
Created attachment 130985 [details]
Screenshot of sheet LML... on desktop libre office, notice missing lines
Comment 11 Rex 2017-02-07 15:06:10 UTC
Created attachment 130986 [details]
Screenshot of sheet LML... on desktop excel
Comment 12 Rex 2017-02-07 15:07:50 UTC
Created attachment 130987 [details]
Screenshot of sheet LML... on laptop libre office
Comment 13 Rex 2017-02-07 15:08:33 UTC
Created attachment 130988 [details]
Screenshot of sheet LML... on laptop excel
Comment 14 Telesto 2017-05-23 17:53:36 UTC
Confirming with:
Version: 5.5.0.0.alpha0+
Build ID: d57e6cd9dcc96112994ca2b14ac45896e86b26e5
CPU threads: 4; OS: Windows 6.19; UI render: GL; 
TinderBox: Win-x86@42, Branch:master, Time: 2017-05-18_22:43:07
Locale: nl-NL (nl_NL); Calc: CL

* With OpenGL lots of scrambled numbers (attachment 130985 [details])
* Without OpenGL it's looking a lot better (but far for perfect)
* PDF export issue exists (but already known bug 104252)

Adding it to the (long) list of similar EMF/WMF issues (bug 103859).
Comment 15 Rex 2018-05-15 08:44:06 UTC
Tried it on 6.0.3.2 
It looks somewhat better, but the output is still incorrect.
Page preview (seitenansicht) looks almost perfect! Unfortunately printing to laser and PDF export do not replicate this.
Numbers in last image  of page are duplicated and placed at top of next page. In other cases (see pages 6-7) graphics and numbers are completely jumbled up. 

"Blatt 1_1(LibreOffice 6.0.3.2 Seitenansicht Drucken auf Papier - alle Tabellen).pdf"
"Blatt 1_1(LibreOffice 6.0.3.2 DirektexportPDF rexw7).pdf"
"Blatt 1_1(LibreOffice 6.0.3.2 Seitenansicht Drucken auf Papier - aktuelle Tabelle).pdf"
"bug17598-Screenshot-SeitenansichtLagermatten-LO6.0.3.2.png"
Comment 16 Rex 2018-05-15 08:46:18 UTC
Created attachment 142105 [details]
PNG - Screenshot of page preview of most jumbled page when printed/exported
Comment 17 Rex 2018-05-15 08:47:44 UTC
Created attachment 142106 [details]
pdf export from libre office 6.0.3.2
Comment 18 Rex 2018-05-15 08:49:35 UTC
Created attachment 142107 [details]
scan of laser printout - all tables - from page preview in libre office 6.0.3.2
Comment 19 Rex 2018-05-15 08:50:20 UTC
Comment on attachment 142105 [details]
PNG - Screenshot of page preview of most jumbled page when printed/exported

in Libre Office Calc 6.0.3.2
Comment 20 Rex 2018-05-15 08:51:22 UTC
Created attachment 142108 [details]
scan of laser printout - current table - from page preview in libre office 6.0.3.2
Comment 21 QA Administrators 2019-05-16 03:13:54 UTC Comment hidden (obsolete)
Comment 22 Rex 2021-05-12 08:49:58 UTC
Created attachment 171912 [details]
PDF export on Libre Office Calc 7.0.5.2

This bug still exits in:

Version: 7.0.5.2 (x64)
Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a
CPU threads: 16; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded

See especially:
* page 4/15 image above table from last cell on previous page
* page 5/15 image above table from last cell on previous page
* page 6/15 image above table from last cell on previous page
* page 8/15 image above table from last cell on previous page
* page 10/15 image above table from last cell on previous page
* page 12/15 image above table from last cell on previous page
Comment 23 Rex 2021-05-12 09:16:46 UTC
Created attachment 171914 [details]
PDF export on Libre Office Calc 7.1.3.2

This bug still exists in:

Version: 7.1.3.2 (x64) / LibreOffice Community
Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1
CPU threads: 16; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded

See especially:
* page 4/15 image above table from last cell on previous page
* page 5/15 image above table from last cell on previous page
* page 6/15 image above table from last cell on previous page
* page 8/15 image above table from last cell on previous page
* page 10/15 image above table from last cell on previous page
* page 12/15 image above table from last cell on previous page
Comment 24 Rex 2022-07-06 14:20:31 UTC
Created attachment 181138 [details]
PDF export from version 7.3.4.2

This bug still exists in v. 7.3.4.2 
Happy to report that the output has improved related to v 7.1.3.2 !

On pages 2/10, 3/10, 4/10, 5/10, 10/10 the text from the last image on the preceding page is replicated on the head of the following page.

On pages 7/10, 8/10 the much more prevalent texts from the last row of images from the preceding page is replicated on the head of the following page.