Bug 138734 - Some information about borders are not saved in xlsx
Summary: Some information about borders are not saved in xlsx
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.3.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-12-08 07:45 UTC by mpele
Modified: 2020-12-08 08:18 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
File for testing (7.98 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-12-08 07:45 UTC, mpele
Details

Note You need to log in before you can comment on or make changes to this bug.
Description mpele 2020-12-08 07:45:34 UTC
Created attachment 167928 [details]
File for testing

During saving ods file as xlsx there is some information lost about border thickness - there are no thicker borders.

Steps to Reproduce:
1) Open test.ods from attachment
2) Save it as xlsx 
3) Open saved xlsx in LibreOffice

Visually the tables are not the same.
Comment 1 Mike Kaganski 2020-12-08 07:51:07 UTC
Excel (and its formats) do not have the concept of border width. We can't save to a format something that is not supported there. That's what the warning tells you about which is shown when you export to non-native format (unless you disable it).

Closing NOTABUG.
Comment 2 Mike Kaganski 2020-12-08 08:12:25 UTC
To clarify: Excel only has border styles. They include several styles that define kind of "thickness": namely "hair", "thin", "medium", and "thick", that is prints as 0.05, 0.75, 1.75, and 2.5 pt wide respectively. Thus LibreOffice has to round the finely defined cell border width towards the nearest Excel's style.

The styles that Excel uses in OOXLM are defined in ECMA-376-1:2016 sect. 18.18.3 ST_BorderStyle (Border Line Styles) [1].

[1] http://www.ecma-international.org/publications/standards/Ecma-376.htm
Comment 3 mpele 2020-12-08 08:18:28 UTC
Oh, I see. The thickness of 1.5 is saved as 0.75 during export to xlsx, but with 1.75 everything is OK.

Thank you for the clarification !!!