Created attachment 73383 [details] screenshot of Excel My XLSX looks weird when opened in LibreOffice 4.0.0.1: * cells with hyperlinks lack the bottom border and have grey background * cells with with conditional formatting sometimes show the numbers not centered and without points; cell borders are not shown * spreadsheet background doesn't get imported * cell borders are thicker than they are in Excel * fonts are changed: Arial & Arial Unicode in original sheet are changed to Calibri Spreadsheet can be downloaded here: http://www.squeezechart.com/SqueezeChart2013-preview.xlsx screenshot from Excel: http://www.squeezechart.com/spreadsheet-in-Excel-15.0.4420.png screenshot from LibreOffice: http://www.squeezechart.com/spreadsheet-in-LibreOffice-4.0.0.1.png
Created attachment 73384 [details] screenshot of LibreOffice
Created attachment 73385 [details] XLSX spreadsheet
This also happens with LibreOffice 3.6.4, 3.6.5 and 4.0.0 final
*** This bug has been marked as a duplicate of bug 62513 ***
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=78f4ed104c832b4aa1ae2d8d367f1db7de486065 correct xlsx element order, related tdf#59663 It will be available in 5.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=de90039b9f04233a87b8dffb9a00ea3f534bc22c actually make the exported file valid, related tdf#59663 It will be available in 5.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.