Bug 125202 - Fileopen: Lines from MSO xlsx are misplaced in Calc because merged cell font and spacing are wrong
Summary: Fileopen: Lines from MSO xlsx are misplaced in Calc because merged cell font ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: filter:xlsx
Depends on:
Blocks: XLSX
  Show dependency treegraph
Reported: 2019-05-10 08:58 UTC by TZP
Modified: 2019-05-13 11:49 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

arrows-LO.png (52.40 KB, image/png)
2019-05-10 08:59 UTC, TZP
arrows-excel.png (27.86 KB, image/png)
2019-05-10 09:00 UTC, TZP
arrows.xlsx (20.29 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-05-10 09:01 UTC, TZP
arrows.xlsx (19.81 KB, application/octet-stream)
2019-05-10 12:18 UTC, TZP

Note You need to log in before you can comment on or make changes to this bug.
Description TZP 2019-05-10 08:58:26 UTC
Lines/arrows drawn in an xlsx file are misplaced when opening the file in LO calc.

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]
Comment 2 TZP 2019-05-10 09:00:09 UTC
Created attachment 151288 [details]
Comment 3 TZP 2019-05-10 09:01:50 UTC
Created attachment 151289 [details]
Comment 4 TZP 2019-05-10 09:02:41 UTC
Comment on attachment 151287 [details]

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

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]

Uploading the xlsx again.
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.