Bug 125202

Summary: Fileopen: Lines from MSO xlsx are misplaced in Calc because merged cell font and spacing are wrong
Product: LibreOffice Reporter: TZP <zoltan.peter.toth>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: CLOSED DUPLICATE    
Severity: normal CC: rb.henschel
Priority: medium Keywords: filter:xlsx
Version: 5.1.6.2 release   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=123613
https://bugs.documentfoundation.org/show_bug.cgi?id=104289
https://bugs.documentfoundation.org/show_bug.cgi?id=112561
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108897    
Attachments: arrows-LO.png
arrows-excel.png
arrows.xlsx
arrows.xlsx

Description TZP 2019-05-10 08:58:26 UTC 
Description:
Lines/arrows drawn in an xlsx file are misplaced when opening the file in LO calc.

Attached:
arrows.xlsx: the excel file
arrows-excel.png: how it looks when opened in ms excel.
arrows-LO.png: how it looks when opened in LO calc.

Steps to Reproduce:
1.Open the attached xlsx in excel. The arrows are placed correctly.
2.Open the attached xlsx in LO calc. The arrows are misplaced.


Actual Results:
See arrows-LO.png

Expected Results:
See arrows-excel.png


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 TZP 2019-05-10 08:59:24 UTC 
Created attachment 151287 [details]
arrows-LO.png
Comment 2 TZP 2019-05-10 09:00:09 UTC 
Created attachment 151288 [details]
arrows-excel.png
Comment 3 TZP 2019-05-10 09:01:50 UTC 
Created attachment 151289 [details]
arrows.xlsx
Comment 4 TZP 2019-05-10 09:02:41 UTC 
Comment on attachment 151287 [details]
arrows-LO.png

Misplaced arrows
Comment 5 TZP 2019-05-10 09:03:11 UTC 
Comment on attachment 151288 [details]
arrows-excel.png

Correctly placed arrows
Comment 6 TZP 2019-05-10 09:03:35 UTC Comment hidden (obsolete)
Comment 7 Timur 2019-05-10 10:53:19 UTC 
We always need to know whether XLSX was created in MSO (but this one cannot be open!) or in LO (we don't need it, rather we need source ODS).
Please clarify, make sure you write exact steps to reproduce (not just what you see as a final problem) and set back as Unconfirmed.
Comment 8 TZP 2019-05-10 12:11:21 UTC 
The xlsx file was created with MSO.
Comment 9 TZP 2019-05-10 12:18:11 UTC 
Created attachment 151292 [details]
arrows.xlsx

Uploading the xlsx again.
MD5:
58d5422efc018b2817031098e60bec21  arrows.xlsx
Comment 10 Timur 2019-05-10 14:58:51 UTC 
Repro LO 6.3+ in Windows. No time to check whether this is a duplicate.
Comment 11 Regina Henschel 2019-05-10 23:30:37 UTC 
The problem is not with the lines, but the text has a different line spacing than in Excel.
Comment 12 Timur 2019-05-13 11:49:08 UTC 
Merged cell content is not properly imported. 
LO 6.2 and before were showing Calibri 11 for cell and character font. But copy would result in font size 9. That seems changed in LO 6.3+. Instead of Calibri 11, font is shown as Liberation Serif 11. 
Line spacing is also different but I don't see how it can be changed.
Comment 13 NISZ LibreOffice Team 2020-08-28 11:15:34 UTC 
(In reply to Regina Henschel from comment #11)
> The problem is not with the lines, but the text has a different line spacing
> than in Excel.

That's bug #112561. Let's make this a duplicate.

(In reply to Timur from comment #12)
> LO 6.2 and before were showing Calibri 11 for cell and character font. But
> copy would result in font size 9. That seems changed in LO 6.3+. Instead of
> Calibri 11, font is shown as Liberation Serif 11. 

I don't see this happening in 6.3/6.4/7.0 on Windows: it's always Calibri 11 for me.

*** This bug has been marked as a duplicate of bug 112561 ***
Comment 14 Hudson James 2021-05-18 15:40:58 UTC Comment hidden (spam)