Steps to reproduce: 1. open Calc 2. Select a cell 3. Formate - Cells - Borders: Set line width to 3,00 pt Line arrangement: "Set all Four Borders" 4. Save as XLS (Excel 97/2000/XP...) and close it. 5. Reopen the XLS: the borders are reset to default values Expected behavior: custom format should be preserved. Platform Linux i686 / RPM
bug#37622 looks similar
I can confirm this behavior on WinXP (32bit) and LO 3.4 Some thing to add: at #5: I don't think the border line width is reseted to default width. The default width is 0.25 and the reseted line border width is 1.2 (here). Also I noticed that the "spacing to contents" is increased in the xls format (although the border line width is thinner there) compared to the original save in odf, but thats probably the same / subsequent error.
May be 1.2pt is the only width EXCEL knows, and this is a feature, but not a bug? Without knowledge concerning EXCEL border features further LibO investigations are useless
Same with LO LibreOffice 3.4.4 OOO340m1 (Build:402) / Mint Linux 12 amd 64
Created attachment 55544 [details] Border line widths in Excel 2003 Excel Document created with Excel 2003 and the three available border line widths (thin, thicker, thickest)
Created attachment 55545 [details] Border line widths in OpenOffice.org 3.2 ODF Document created with OpenOffice.org 3.2 and the six available border line widths.
Created attachment 55546 [details] Border line widths in LibreOffice 3.4.4 ODF Document created with LibreOffice 3.4.4 and some of the available border line widths.
Created attachment 55547 [details] OpenOffice.org 3.2 document converted to xls with OOo 3.2
Created attachment 55548 [details] LibreOffice 3.4.4 document converted to xls with LO 3.4.4
Created attachment 55549 [details] Border line widths in OpenOffice.org 3.2 ODF Document created with OpenOffice.org 3.2 and the six available border line widths.
Created attachment 55550 [details] Overview of Excel documents in Excel 2003
Created attachment 55551 [details] Overview of Excel documents in Excel 2003
Created attachment 55552 [details] Overview of Excel documents in OOo 3.2
Created attachment 55553 [details] Overview of Excel documents in LO 3.4.4
Created attachment 55554 [details] Overview of *the* Excel document in Excel2003, OOo3.2, LO3.4.4
Sorry for the spamming... So I did some comprehensive testing - my conclusion: In Excel (2003 here) are only three border line width available. When converting from ODF to XLS the (more) variable line widhts in ODF must be converted to the three available line widths in XLS. Apparently this correlation changed in LO 3.4 compared to OOo/ earlier versions. I don't know if this changed correlation is a bug or expected. In LO 3.4 the line widths are still converted to three different widths, but the thicker and thickest line widths are more close by now and look almost the same. However as it seems only LO 3.4 itself is affected by this, the documents themselves still display fine in Excel / OOo. If you take a look at "Overview of Excel documents in Excel 2003", you'll see all line border widths are displayed fine whether they are created/converted from OOo or LO.
I can confirm the bug with LO 3.4.3 on ubuntu 11.10 Micha
Created attachment 55556 [details] Cell A1 with 3pt double line. In LO 3.3.4 and OOo 3.3.0 3pt, in LO 3.5 Beta2 0.3 pt Could not be a only a problem "Which thickness is near the lines of Excel". The example for me: The doule-lines. Edited in LO 3.3.4 with 3pt, opended in OOo: 3pt, opened in LO 3.5 Beta2: 0.3pt. I have seen this unter Linux-rpm-32bit.
From LibO 3.3 to 3.4 the flexibility or CALC border styles has been improved a lot, and that will not make it easy to find a conversion rule. I agree, we should try to improve results. I do not use EXCEL and have no document interchange with EXCEL documents, so I have no experience. But it seems tat that is a "real life problem". I do not know whether there already is activity concerning this. I will try to find out our emphasis concerning MS / Office Open XML compatibility during the next TSC call and leave the results here.
Addendum note: If you edit the converted LO 3.4.4 XLS document and save it again as XLS, then the line border widths actually changes in Excel / OOo view. The thickest line width is converted to thick, the thick lines to thin and the thin lines remain as thin lines. This happens only once, so further editing doesn't reduce all lines to thin lines. So I guess that the "border line width correlation table" is a little mis-adjusted.
*** Bug 42665 has been marked as a duplicate of this bug. ***
Another incarnation of BorderLine rework, with test cases.
I will take a look at that one and maybe some other border import/export problems.
(In reply to comment #22) > Another incarnation of BorderLine rework, with test cases. And this one was not the result of BorderLine rework. It seems that this was an old Go-Oo bug. The patch introducing this strange behavior was an go-oo patch changing the border line widths in xls import but not in xls export. I fixed it now by moving the definion of the border width that is used in xls import/export in a common header file so that both import and export are using this now.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4ab9719f15baddbc60b96d86d2e0878e79a6ddf7 use same border width information for xls import and export, fdo#44742
*** Bug 47402 has been marked as a duplicate of this bug. ***
*** Bug 46960 has been marked as a duplicate of this bug. ***
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-3-5": http://cgit.freedesktop.org/libreoffice/core/commit/?id=487139d681fbf38a52cf5ea91d7e38f7eba290a0&g=libreoffice-3-5 use same border width information for xls import and export, fdo#44742 It will be available in LibreOffice 3.5.3.
*** Bug 44114 has been marked as a duplicate of this bug. ***