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).
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
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.
Created attachment 186645 [details] 154738 export to xml 2
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.