Created attachment 126344 [details] If you open it with LibreCalc, it will be fine. But if you open with Excel 2007, it will fail I save the xlsx from LibreCalc. When I open it with Excel 2007, it gives me error "Excel found unreadable content in *******.xls. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click yes" I have tried to follow the suggestion from https://bugs.documentfoundation.org/show_bug.cgi?id=42906 (Tools -> Options -> Load/Save -> General, choose the ODF format version > ODF 1.0/1.1) and it does not help. Attached is the example file.
No such problem with Excel 2013. I also saved it from LibreOffice and again it opened fine in Excel. Not sure, if we should care about interoperability with obsolete MSO versions? Win 8.1 32-bit MSO 2013 LibO Version: 5.3.0.0.alpha0+ Build ID: 9f8f6e032a61beaddeaa3bf3bb0ed08581c15b17 CPU Threads: 4; OS Version: Windows 6.29; UI Render: default; TinderBox: Win-x86@42, Branch:master, Time: 2016-08-03_08:09:13 Locale: fi-FI (fi_FI); Calc: group
I don't have such problems with MS Excel 2010
After open corrupted file, please save it again with Excel 2007 into .xlsx. Is it solve that opening issue? Please attach this file which you have resaved.
Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document.
I tried it with Excel 2010, it works. If this really works only with Excel 2010 onward, should the "save as type" in the combo box' Save As dialog be changed from "Microsoft Excel 2007-2013 XML (.xlsx)(*.xlsx)" to "Microsoft Excel 2010-2013 XML (.xlsx)(*.xlsx)"?
@pintubigfoot I would like to resolve this issue by fixing LibreOffice, to produce Office 2007 compatible .xlsx documents. To resolve that I need your help (as I don't own Office 2007): 1. Please open document attached by you in Office 2007 2. When error appears, please provide screenshot of it. 3. Save again .xlsx document (different name) and attach to this bug report. 4. Please check if the problem still exists (in Office 2007) with re-saved document It will dramatically simplify resolving of this issue
Created attachment 128241 [details] screenshots, the error message, and the xlsx saved with excel 2007, Hello Bartosz, Glad to hear that. Attached are the screenshots, error message, and xlsx. Let me know if you need some more info. Thanks.
Created attachment 128257 [details] Fix 1 Please check which fixed file is wotking for you.
Created attachment 128258 [details] Fix2
Created attachment 128259 [details] Fix3
Created attachment 128260 [details] Fix4
Created attachment 128261 [details] Fix5
(In reply to Bartosz from comment #13) > Created attachment 128261 [details] > Fix5 Hi Bartosz, Thanks for the fast response, and apologies for delay. Fix5 resolves the problem! The Excel 2007 opens that file perfectly without any error. In what version can this be planned to be part of LibreCalc release?
Here is the review for the fix: https://gerrit.libreoffice.org/#/c/30960/
Okay, I will be monitoring from there. Thanks!