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. Expected results: 2. Double-line cell borders are shown. 4. Double-line cell borders are shown. 5. Double-line cell borders are shown. Actual results: 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: 7.0.4.2 (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 Calc: threaded And on Ubuntu Linux (official package): Version: 7.0.3.1 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 Calc: threaded
Created attachment 169321 [details] XLSX export
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 <meta:generator>LibreOffice/7.0.4.2$Windows_x86 LibreOffice_project/dcf040e67528d9187c66b2379df5ea4407429775</meta:generator> So it was not created with 7.2.
Created attachment 170782 [details] Video of test step 1
Dear Johnny_M, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
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, and then saving this ods file as xlsx, reopening the ods file and saving it as xls, all three files are shown correctly in LO and in Excel online in terms of style. There _seems_ to be some minor difference in color. I have not tested / checked border colors, only the "double" style. I have not tested different thickness / border widths. I have not tested the previously-attached files. Warning / note: 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 have just tried to reproduce this bug using 7.5.0.3 without success. Both the the original ods and a newly created ods displayed fine in MS Excel and after saving as XLSX and then loading in Libreoffice. Have changed status as per email to me dated 28 Mar 2023, 14:21.
(In reply to ady from comment #14) > Warning / note: > > 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). This part (exporting XML) still needs a solution.
(In reply to ady from comment #16) > This part (exporting XML) still needs a solution. That's a new report, bug 154738 now.