Created attachment 116226 [details] comparison of original and reopened file 1. Given an simple Excel-Sheet with one formula in a field. 2. Formula is in the form: "=SUMME(Y2:Y30)". 3. Modifying the sheet somewhere in order to trigger the save warning. 4. Select "Save" and on the warning choose "Use Microsoft Excel 2003 XML-Format". It saves and the content of the current open spreadsheet window stays as is. 5. Close the sheet. 6. Reopen the file and look at the cell with the formula. It now is destroyed and shows as being changed to the following text string: of:]=SUM([.Y2:.Y3])
Additional information: After reopening the Excel-Sheet and manually retyping the "SUM"-formula, then saving again as Excel 2003 XML, closing and reopening that, the same modification takes place.
Hello Nico, Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document. (Please note that the attachment will be public, remove any sensitive information before attaching it.) How can I eliminate confidential data from a sample document? https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F Thank you
Created attachment 116241 [details] Saving the xls-document
Created attachment 116242 [details] Reopening
Created attachment 116243 [details] Sample-file
I have added the sample xls-file. It is the xls-file already opened in LibreOffice 4.4.3.2 and saved as Excel 2003 XML and then reopened. The application that originally generated the file unfortunately does not allow for anonymous data export.
Excel 15 for OSX tells me that the file in invalid xml, and there is an error with HTML style import displayed beforehand. The file then fails to open in Excel 15.
Cell W3 displays : of:]=SUM([.W2:.W2]) Cells X3 and Y3 are also incorrect in LO 4432 OSX 10.10.3
In short: do not use the interim Excel 2003 XML file format, it is exported/imported only via an XML style sheet transformation and not maintained. Use either ODF OpenDocument .ods or Excel 2007-2013 XML .xlsx file format.