Download it now!
Bug 135957 - Excel and Calc borders not cross-compatible
Summary: Excel and Calc borders not cross-compatible
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Border
  Show dependency treegraph
 
Reported: 2020-08-20 18:32 UTC by Rafael Lima
Modified: 2020-09-09 13:07 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Default Excel borders appear thicker on LO Calc (455.68 KB, image/jpeg)
2020-08-20 18:33 UTC, Rafael Lima
Details
Default Calc borders appear as dashes on Excel (463.81 KB, image/jpeg)
2020-08-20 18:34 UTC, Rafael Lima
Details
Zip file with the ODS and XLSX files for both Scenarios (35.48 KB, application/zip)
2020-09-09 13:00 UTC, Rafael Lima
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Rafael Lima 2020-08-20 18:32:17 UTC
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.
Comment 1 Rafael Lima 2020-08-20 18:33:21 UTC
Created attachment 164506 [details]
Default Excel borders appear thicker on LO Calc
Comment 2 Rafael Lima 2020-08-20 18:34:25 UTC
Created attachment 164507 [details]
Default Calc borders appear as dashes on Excel
Comment 3 Timur 2020-09-09 08:58:52 UTC
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.
Comment 4 Rafael Lima 2020-09-09 13:00:15 UTC
Created attachment 165321 [details]
Zip file with the ODS and XLSX files for both Scenarios
Comment 5 Rafael Lima 2020-09-09 13:07:02 UTC
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.