Bug 154738 - Double-line cell borders not exported to XML
Summary: Double-line cell borders not exported to XML
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: MSO-XML2003
  Show dependency treegraph
Reported: 2023-04-10 00:19 UTC by ady
Modified: 2023-04-13 22:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

154738 export to xml 1 (11.74 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-04-13 22:40 UTC, ady
154738 export to xml 2 (11.71 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-04-13 22:41 UTC, ady

Note You need to log in before you can comment on or make changes to this bug.
Description ady 2023-04-10 00:19:25 UTC
Spin-off of

Creating an ods file with:
Version: (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: (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.