Bug 153373 - FILEOPEN LibreOffice doesn't open MS Office templates correctly
Summary: FILEOPEN LibreOffice doesn't open MS Office templates correctly
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: filters and storage (show other bugs)
Version:
(earliest affected)
7.5.0.3 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-02-04 12:01 UTC by Frank Reibold
Modified: 2023-11-23 06:24 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
template1 (4.14 MB, application/vnd.openxmlformats-officedocument.wordprocessingml.template)
2023-02-04 12:03 UTC, Frank Reibold
Details
template 2 (1.85 MB, application/vnd.openxmlformats-officedocument.wordprocessingml.template)
2023-02-04 12:03 UTC, Frank Reibold
Details
expected results (5.33 MB, application/x-zip-compressed)
2023-02-04 12:04 UTC, Frank Reibold
Details
Result with LO 7.2.0.1 (574.29 KB, application/pdf)
2023-02-04 17:27 UTC, Frank Reibold
Details
Result with LO 7.4 (287.48 KB, application/pdf)
2023-02-04 17:29 UTC, Frank Reibold
Details
Fashion PDF export, LO 7.6 (588.88 KB, application/pdf)
2023-03-30 15:31 UTC, Frank Reibold
Details
Fashion PDF print result, LO 7.6 (570.74 KB, application/pdf)
2023-03-30 15:32 UTC, Frank Reibold
Details
Restaurant PDF export with 7.6 (475.60 KB, application/pdf)
2023-03-30 15:37 UTC, Frank Reibold
Details
Restaurant PDF print with 7.6 (570.74 KB, application/pdf)
2023-03-30 15:37 UTC, Frank Reibold
Details
Restaurant PDF print with Writer 7.6 (512.59 KB, application/pdf)
2023-03-31 12:56 UTC, Frank Reibold
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Frank Reibold 2023-02-04 12:01:21 UTC
Description:
I tried to open some MS Office templates

The resulting documents are one page too long because one page is included twice but with a different layout. There have always been problems with these templates but in version 7.5.0.3, some text is missing.


Steps to Reproduce:
1.Load template https://templates.office.com/DE-DE/fashion-newsletter-TM16412247 and open it.
2.Load template https://templates.office.com/DE-DE/restaurantnewsletter-TM44813192 and open it.

Actual Results:
Layout problems

Expected Results:
Smooth import


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.5.0.3 (X86_64) / LibreOffice Community
Build ID: c21113d003cd3efa8c53188764377a8272d9d6de
CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded
Comment 1 Frank Reibold 2023-02-04 12:03:17 UTC
Created attachment 185105 [details]
template1
Comment 2 Frank Reibold 2023-02-04 12:03:50 UTC
Created attachment 185106 [details]
template 2
Comment 3 Frank Reibold 2023-02-04 12:04:47 UTC
Created attachment 185107 [details]
expected results
Comment 4 m_a_riosv 2023-02-04 16:42:50 UTC
What is the missing test?
Comment 5 m_a_riosv 2023-02-04 16:52:11 UTC
Seems it is a little different on top/bottom margin of the 'converted1' font style, from 0,76 to 0,70.
Comment 6 Frank Reibold 2023-02-04 17:26:08 UTC
Some text is missing, too. LO Writer 7.2 was better and 7.4 at least had the text.
Comment 7 Frank Reibold 2023-02-04 17:27:30 UTC
Created attachment 185109 [details]
Result with LO 7.2.0.1
Comment 8 Frank Reibold 2023-02-04 17:29:28 UTC
Created attachment 185110 [details]
Result with LO 7.4

The results with the other template are similar.

It seems that in this respect LO Writer 7.5 is worse than 7.4, which itself is worse than 7.2.
Comment 9 Frank Reibold 2023-02-04 17:31:38 UTC
You can see the missing text in the PDF files.
Comment 10 raal 2023-03-02 17:18:02 UTC
Can you please test it with 7.6 dev version? I see the text, there is no duplicity of pages, but pdf export is broken.  You can download it here:
http://dev-builds.libreoffice.org/daily/master/
Thank you

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 4e6ab75c1a907398d24768d19cf097a4892d374c
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: x11
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded
Comment 11 Frank Reibold 2023-03-03 14:01:40 UTC
Thank you very much!

You are right -- the PDF export is broken.

Exporting the files via a virtual PDF printer like PDFill PDF almost works.

The text is visible but the layout is still a bit different from MS Word 2013. The page numbers on pages 2 to 4 of the fashion template are missing.
Comment 12 Buovjaga 2023-03-29 12:22:29 UTC
(In reply to Frank Reibold from comment #11)
> Thank you very much!
> 
> You are right -- the PDF export is broken.
> 
> Exporting the files via a virtual PDF printer like PDFill PDF almost works.
> 
> The text is visible but the layout is still a bit different from MS Word
> 2013. The page numbers on pages 2 to 4 of the fashion template are missing.

Raal, Frank: can you please point out how the PDF export is broken?

I have reported earlier the issue with the squished images in the Fashion template: bug 136082. This issue is visible even just by opening the file.
Comment 13 Frank Reibold 2023-03-30 12:44:45 UTC
The problem was that LO Writer 7.6 DEV displays the template almost correctly but that the PDF export adds one or more pages. If you use a virtual PDF printer, you get 4 pages.

The current Writer 7.5.2.2 doesn't display the template correctly.
Comment 14 Buovjaga 2023-03-30 12:46:00 UTC
(In reply to Frank Reibold from comment #13)
> The problem was that LO Writer 7.6 DEV displays the template almost
> correctly but that the PDF export adds one or more pages. If you use a
> virtual PDF printer, you get 4 pages.
> 
> The current Writer 7.5.2.2 doesn't display the template correctly.

Yeah, but HOW?
Comment 15 Frank Reibold 2023-03-30 15:31:22 UTC
Created attachment 186325 [details]
Fashion PDF export, LO 7.6

This is the PDF of the fashion template, exported with LO Writer 7.6
Comment 16 Frank Reibold 2023-03-30 15:32:35 UTC
Created attachment 186326 [details]
Fashion PDF print result, LO 7.6

The resukt of printing the fashion template to a virtual PDF printer with LO 7.6 DEV
Comment 17 Frank Reibold 2023-03-30 15:34:58 UTC
It seems that the LO 7.6 results are okay, even with the PDF export.
Comment 18 Frank Reibold 2023-03-30 15:37:14 UTC
Created attachment 186327 [details]
Restaurant PDF export with 7.6
Comment 19 Frank Reibold 2023-03-30 15:37:38 UTC
Created attachment 186329 [details]
Restaurant PDF print with 7.6
Comment 20 Frank Reibold 2023-03-30 15:39:18 UTC
As you can see, the PDF export of the restaurant template misses some text on the first page, for example. The PDF print result shows the text.

That's the "broken PDF export" referred to above.
Comment 21 Buovjaga 2023-03-30 16:35:24 UTC
(In reply to Frank Reibold from comment #19)
> Created attachment 186329 [details]
> Restaurant PDF print with 7.6

This is not the restaurant template, but the fashion one
Comment 22 Frank Reibold 2023-03-31 04:40:20 UTC
You are right.

The restaurant template would show some text in the box on page one but the text is missing if you export the PDF.
Comment 23 Frank Reibold 2023-03-31 12:56:31 UTC
Created attachment 186363 [details]
Restaurant PDF print with Writer 7.6
Comment 24 Frank Reibold 2023-11-23 05:58:10 UTC
The bug has been fixed.

Both documents look good with LibreOffice Writer 7.6.3.1.