Description: We got a XLSX-File with 12 sheets for working time summary. Three Employees are filling it in. They sent it to the head quarter. There they could not open it again with the origin Excel 2013. I am an voluntary and the only responsible person for IT in this non-profit organisation. I heard from that prob yesterday and does not know, how many months it persists. I tested it with the same LO and Excel 2007. It could open the file with error messages. These error messages I will attach. Therefore I am planning for 2017 to recommend, to use consistent Office-SW. That means, buying and installing MS Office 2013 in our Office too. I am not happy with it. Otherwise I prefer to use LO furthermore, if that problem could be solved. Can this be replicated? Steps to Reproduce: 1.LO opened and filled a XLSX sheet from a Excel 2013 user. 2.LO saved it / It has been sent to a Excel 2013 user. 3.This user could NOT be open the file again. (in Excel 2013) Actual Results: a Excel 2013 user could not open the XLSX-file, edited by LO. Expected Results: XSLX-compatibility Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.99 Safari/537.36 OPR/41.0.2353.69
Created attachment 129276 [details] Excell 2007 repaired and opened the XSLX
Created attachment 129277 [details] Excell 2007 compatibility check after opening
Created attachment 129278 [details] Excell 2007 first open error
Created attachment 129279 [details] Excell 2007 error list
Created attachment 129280 [details] Excell 2013 error (maybe more than one)
Unfortunately without .xlsx file which cause error we cannot do much. Could you please remove private information from that .xlsx file, make sure that error is still exists and attach it to bug report? If it is impossible please send it to me on my mail. I will investigate root cause of problem and will try to make a fix in LibreOffice 5.3 Some similar errors were also fixed in LibreOffice 5.3 Beta1. Please download LibreOffice 5.3 and check if this issue was already resolved for you. Best Regards Bartosz
Created attachment 129319 [details] XSLX File (anonymized, I hope)
I followed the recommendation of Bartosz (2016-12-04 22:49:20 UTC) LO5.3.beta could not save a copy of the original, not edited (anonymized) file, so i anonymized it with Excell2007 and attached it to the thread. LO was been cancelled manually after 1min with 25%processor and about 1.600kb. It did not respond any more. I opened the original file in LO5.1.6.2 and this version is able to save a copy! I am now anonymized it (with LO) and attached it. The incompatibility exists furthermore.
For issue with LibreOffice hang I created bug 104451
Created attachment 129363 [details] XSLX File (anonymized) after resave with LibreOffice 5.2.3 I have resaved anonymized file with LO 5.2 and after open it with MS Excel 2013 I cannot reproduce this issue. @Harald Could you please try confirm, if this issue exists also for LibreOffice 5.2?
Created attachment 129365 [details] See commend Test03
Created attachment 129366 [details] See commend Test03
I am using LO since its start - so it is ok, to help with this, what I am able to. Test03 The only downloadable LO version is 5.2.3.3, I'm using that. Anonymized with excell2007 XLSX copy with LO5.2.3.3 THERE IS NO PROB WITH THE INTERCHANGEABILITY / LO5.3.beta crashes at saving file. I am attaching: az(excel2007anonymized).xlsx and az(copy LO5.2.3.3).xlsx
This bug was already resolved with LibreOffice 5.3. You could download latest images, which contain the fix from: http://dev-builds.libreoffice.org/daily/libreoffice-5-3/
Thank you, Bartosz! I could reproduce your solution.
Bartosz, you're doing a great work. If a specific commit/fix is not known, then it's not marked Fixed, but rather WorksForMe.