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). Best regards Mirosław Zalewski
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. Kind regards, Joren
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. Kind regards, Joren
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 ***