[Libreoffice-bugs] [Bug 79787] Normal cell borders are showing dashed/dotted when export to xlsx/xls and reopen in MSO

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=79787

--- Comment #52 from Rafael Lima <rafael.palma.lima at gmail.com> ---
Created attachment 169205
  --> https://bugs.documentfoundation.org/attachment.cgi?id=169205&action=edit
Screenshots of both files opened on Excel

I would like to share a brief experiment I did to explain why I think the
compatibility of borders between Calc and Excel can be improved.

What I did is:
1) I created a file on Calc (ODS) with a table formatted with the default
borders. I saved it as ODS (see file Border_Test.ods attached)
2) Then I exported the ODS file to XLSX (see file Border_Test.xlsx attached)
3) I opened the exported XLSX file on Excel and the border is dashed/dotted
4) I opened the ODS file on Excel (Office 365 can open ODS files) and the
borders were normal, as expected.

I attached a file Border_Calc_Excel.odg with screenshots from steps 3 and 4.

If Excel can open an ODS file and convert border information as expected, than
I believe that it is possible to have Calc save the XLSX file in a way that the
border won't appear dashed on Excel.

I had the same results using both LO 7.0.4.2 and 7.2 alpha (daily builds).

I'd like to point out that this is a major compatibility issue between Calc and
Excel. Anyone formatting their tables with default borders on Calc and saving
as XSLX will experience this problem. I use Calc in my lectures all the time
and then, when I export to XSLX, I have to fix all my borders manually before
sending the files to anyone.

Fixing this bug will be a great contribution to the compatibility between ODS
and XLSX files.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210128/4f591428/attachment.htm>