Description: Sheet in .odf format has varying number of text cells in each line. Each text cell has 4-edge box around. When saving sheet in .xlsx format, certain cells loose the bottom edge. Steps to Reproduce: 1) Open the attached sheet HindenburgAner_6.ods 2) Go to cell H39 Sophie ... at cell address F:9 3) Verify text is boxed in with all 4 edges present 4) Save the sheet in Excel 2007-365 format suffix .xlsx 5) Open sheet HindenburgAner_6.xlsx 6) Inspect cell H39 again, the lower edge of the box is now missing. This is considered an error. Actual Results: Certain cells have only 3 edges Expected Results: All cells should have 4 edges Reproducible: Always User Profile Reset: No Additional Info: These files will be attached HindenburgAner_6.ods HindenburgAner_10.ods Text file with instructions and explanations
Created attachment 201310 [details] Sample used to show single error
Created attachment 201311 [details] sample with multiple errors
Created attachment 201312 [details] Instructions and explanations
Opening the ODS, cloning the format from G34 to G35, Saving as XLSX, Reopening, format in G35 is fine. Version: 25.2.4.3 (X86_64) / LibreOffice Community Build ID: 33e196637044ead23f5c3226cde09b47731f7e27 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: en-US (es_ES); UI: en-US Calc: CL threaded
Thank you for reporting the bug. I can confirm that the bug is present in 25.2.4.3 (X86_64) testing under Win 7. I was able to replicate with both of the test files. Note that when the file is initially saved and displayed in Calc the borders remain as expected but on closing and reopening, the .XLSX file certain borders will be missing.