Created attachment 74551 [details]
Sample document as seen in MS Office 2013 (reference)
While importing files created by Excel 2010 and 2013, LibreOffice adds additional width to cell borders - they appear heavier (wider) in LO than in MSO.
I am attaching:
- screenshot from MS Office 2013 (under Windows 8)
- screenshot from LibreOffice 4.0.0 (under Windows 8)
- sample spreadsheet file created by MSO. This file contains some strings in Polish, but I do not own MSO and I am afraid to translate it, as LO save filter may kick in. So here is translation:
* "Cienkie" = "thin"
* "Średnie" = "medium"
* "Średnie przerywane" = "medium dashed"
* "Grube" = "thick"
On side note, Excel "dashed" is imported to LibreOffice as "solid". This is probably related to https://bugs.freedesktop.org/show_bug.cgi?id=48282 .
I could reproduce this on LibreOffice 3.6.5, Debian GNU/Linux (amd64). Original images were taken at LibreOffice 4.0.0, Windows 8 (arch unknown).
Created attachment 74552 [details]
Sample document as seen in LibreOffice 4.0.0
Created attachment 74553 [details]
Sample document for testing purposes
I can reproduce this behavior using Mac OSX 10.8.2 and verifying using Excel (for Mac) 2011. Therefore I mark this as NEW.
The difference isn't that big when I export both documents to PDF.
Created attachment 74559 [details]
pdf difference between Excel (for Mac) and LibreOffice
Can reproduce this. This seems to be a known problem, Bug #52578 and #58356 may be related.
It seems that border widths are improperly handled at import - some kind of values rounded up or something similar.
@Thomas: please do not delete me from the QA field.
Jorendc: Sorry this was not my intention.
I am providing this comment in the hopes of offering some clarity. Bug #58356 referenced in comment #5 has been marked as a duplicate of bug #56960 which initially outlined a series of problems but now appears to deal solely with a XLSX cell border issue. Bug #56960 appears related to bug #53287 which has also had a rather rough life but again deals with XLS/XLSX cell border issues.
I think those last two bugs are currently awaiting UX advice on two issues: a) how to treat the particular issue of displaying / rendering cell border widths on screen; b) whether to restrict the number of possible cell border widths to only a few values (as OOXML does). Bug #48282 seems related to these two bugs as well. I will leave it to Mirosław and Joren to determine how and to what extent this bug may relate to these issues and what to do about it.
Comment #5 also references bug #52578 which is a different issue and a clearer bug - that of incrementing cell border widths (up to 4.00pt/thick) each time an XLSX is saved. I have commented in that bug to try and provide a clearer picture of what appears to be occurring.
This seems to be the same issue as shown in Bug 56960.
*** This bug has been marked as a duplicate of bug 56960 ***