There is an incompatibility of cell borders between MS Excel and LO Calc that I have experienced for a long time and I think it is a major issue in using LibreOffice Calc. Whenever I open a Calc file on Excel (or vice-versa), the border thickness is changed. This happens in both directions (From Excel to Calc, and from Calc to Excel). I'll explain how to reproduce both scenarios (see also the attached images for more details). SCENARIO 1 - Steps to reproduce: 1) Create a table on Excel 2) Apply default borders to the table 3) Save the Excel file and exit 4) Open the file on LO Calc 5) Notice that the borders are now a lot thicker SCENARIO 2 - Steps to reproduce: 1) Create a table on LO Calc 2) Apply default borders to the table 3) Save the Calc file and exit 4) Open the file on Excel 5) Notice that the borders are now dashed This problem is a big issue in LibreOffice Calc and MS Excel compatibility, because default cell borders is something almost every spreadsheet has. This bug makes me have to fix all borders in a file every time I convert them.
Created attachment 164506 [details] Default Excel borders appear thicker on LO Calc
Created attachment 164507 [details] Default Calc borders appear as dashes on Excel
1. One must search existing bugs before reporting, and we have a few on borders, did you. 2. "SCENARIO 1 - Create a table on Excel" not XLS and XLSX are the same, please attach both sources 3. "SCENARIO 2 - Save the Calc file" save as what format? please attach.
Created attachment 165321 [details] Zip file with the ODS and XLSX files for both Scenarios
I attached a ZIP file containing ODS and XLSX files that help explain both scenarios. -------------------- Scenario 1 - Step 1.xlsx: This file was created using Excel and I applied Excel's default borders Scenario 1 - Step 2.ods: I opened the previous file using LO Calc and the borders are thicker than expected (after opening the file, I saved it as an ODS file) -------------------- Scenario 2 - Step 1.ods: This file was created using LO Calc and I applied Calc's default borders. First I saved it using the ODS format. Then I saved this file using the XLSX format, which is the file in the next step. Scenario 2 - Step 2.xlsx: This is the exported XLSX file from the previous step. When this file is opened in Excel, the borders will appear dashed.
*** This bug has been marked as a duplicate of bug 79787 ***