Created attachment 169320 [details]
ODS original for test
Double-line cell borders are lost when the file is saved to XLSX and reopened. When re-opened in LO, single-line borders are shown. (While when re-opened in MSO 365 Excel, dotted-line borders are shown, which is the bug 79787.)
MSO 365 Excel correctly displays the original ODS file.
Steps to reproduce:
1. Set borders for a cell, configure them to be double-line borders. (Or open the attached ODS test file example.)
2. Save the file to ODS and re-open the ODS file in MSO 365 Excel.
3. Export the file to XLSX.
4. Open the XLSX file in LO.
5. Open the XLSX file in MSO 365 Excel.
2. Double-line cell borders are shown.
4. Double-line cell borders are shown.
5. Double-line cell borders are shown.
2. Double-line cell borders are shown. (OK)
4. Single-line cell borders are shown. (Not OK)
5. Single-line cell borders are shown (as dotted-line borders - separate bug 79787). (Not OK)
Occurs on Windows (portable LO release):
Version: 184.108.40.206 (x86)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: en-US (de_DE); UI: en-US
And on Ubuntu Linux (official package):
Build ID: 00(Build:1)
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: de-DE (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.0.3-0ubuntu0.20.10.1
Created attachment 169321 [details]
Created attachment 169322 [details]
ODS in LO (correct)
Created attachment 169323 [details]
ODS in MSO (correct)
Created attachment 169324 [details]
XLSX in LO (issue)
Created attachment 169325 [details]
XLSX in MSO (issue)
Created attachment 169326 [details]
XLSX export usng Excel (correct)
When the ODS file is opened in MSO 365 Excel and exported to XLSL there, double-line borders are shown correctly on subsequent reopening both, in LO and Excel.
Created attachment 169327 [details]
XLS export usng Excel (correct)
Exactly the same behaviour if the older XLS format is used instead of the XLSX.
Repro 7.2+, filesave of ODS as XLSX or XLS in LO is wrong both in LO and MSO.
attachment 169320 [details] is simple, but bug is there for all double border types.
All double borders were never correct but some were, like one in attachment in LO 5.0. LO 6.0 is wrong. So this is either regression or at least needs bibisect.
Not sure why this is not the case with attachment 122863 [details] from bug 55266.
Something is wrong with attachment 169320 [details]. In 5.0, it is rendered with a single line style, but the format cell dialog shows a blank style in the dropdown. In 6.3 and master, it is rendered with double line style, but the format cell dialog shows single line style.
If I assign the double line style in master with a new document, there is no problem with XLSX export.
Johnny_M: how was attachment 169320 [details] created (in which version of LibO)?
Hm, created with 7.2 alpha0.
(In reply to Timur from comment #10)
> Hm, created with 7.2 alpha0.
I got curious and unzipped the file. In meta.xml there is
So it was not created with 7.2.
Created attachment 170782 [details]
Video of test step 1