Bug 154738

Summary: Double-line cell borders not exported to XML
Product: LibreOffice Reporter: ady <adylo811517>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: ilmari.lauhakangas
Priority: medium    
Version: 3.6.0.4 release   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=140032
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 113869    
Attachments: 154738 export to xml 1
154738 export to xml 2

Description ady 2023-04-10 00:19:25 UTC 
Spin-off of
https://bugs.documentfoundation.org/show_bug.cgi?id=140032#c14

Creating an ods file with:
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 67bb7f71b785d3d831ffaa47262b6cbd84e71c42
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (es_AR); UI: en-US
Calc: threaded
Built 2023-03-25

...containing cells with double border style and width of 1.5pt.

Exporting from LO as xml and opening it in LO and in Excel online > both show the xml file incorrectly, especially when testing a range of contiguous cells (as opposed to testing one cell alone, which fails too).
Comment 1 Buovjaga 2023-04-13 12:37:35 UTC 
I downloaded attachment 169320 [details].
I selected the cell with the border and filled it down to the cell below with Ctrl-D.

File - Export - Microsoft Excel 2003 XML. Closed, opened the XML. The borders were gone.

Having just a single cell worked.

Tested with 6.0, 5.0, 3.6.

Arch Linux 64-bit, X11
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 9470fca71139f9e439ce61b4c93dd33022c2cc6d
CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 13 April 2023
Comment 2 ady 2023-04-13 22:40:35 UTC 
Created attachment 186644 [details]
154738 export to xml 1

In order to see the problem more clearly, I am attaching 2 ods files.

The files are similar, with only one range of cells with a different format between them.

Exporting each of them to XML should had shown the "in-common" ranges with the same result, and the only difference should had been the only range that is different between both ods files.

But that's not the case. The export filter is not dealing consistently with each cell border's format. Instead, the format of a certain range of cells is influenced by the format of other range of cells.
Comment 3 ady 2023-04-13 22:41:27 UTC 
Created attachment 186645 [details]
154738 export to xml 2
Comment 4 ady 2023-04-13 22:52:17 UTC 
When comparing the respective XML files (exported from attachment 186644 [details] and attachment 186645 [details] from comment 2 and comment 3 respectively), the resulting format of the range K9:M11 should had been the same for both exported XML files, but they aren't.

That's in addition to other differences in comparison to the two original ods files, but first the export filter should be consistent.