Created attachment 84130 [details] Test file created in Excel 2007 based on Kohei's test file, but only 87 rows Problem description: When you open a .ods created with Excel, LibreOffice appends "msoxl:" before the formula. A "=A1*1.1" thus becomes "msoxl:=A1*1.1", which can only be evaluated as text. Steps to reproduce: 1. Excel 2007: Create a new worksheet 2. Excel 2007: Enter formulas as per Kohei's shared-formula-memory-test.ods (see "http://kohei.us/2013/08/15/shared-formula-to-reduce-memory-usage/") 3. Excel 2007: File > Save As > Open Document Spreadsheet" 4. LibreOffice 4.1: Open the above document Current behavior: Cells contain text that can not be evaluated as formula. Example for row "B", in column order: "msoxl:=A1+1", "msoxl:=A2*1.1", "msoxl:=B2/100*PI()", "msoxl:=SUM(A2:C2)" Expected behavior: Cells should contain formulas. Example for row "B", in column order: "=A1+1", "=A2*1.1", "=B2/100*PI()", "=SUM(A2:C2)" System: Windows 7 SP1 64-bit [en], MSO Excel 2007 SP3 [sl], LibreOffice 4.1.0.4 Release [en] Operating System: Windows 7 Version: 4.1.0.4 release
Excel 2007 and 2010 write only ODF 1.0/1.1 ISO/IEC 26300:2006 and write formula expressions in their own msoxl namespace, syntax and semantics. We do not support that. Excel 2013 properly supports ODF 1.2 including the OpenFormula (ODFF) specification.
@Eicke: So basically you are saying that: 1) we shall not succumb to Microsoft's EEE (or KKK, NWO or other 3 letter policies) 2) if we want to use such files in LibreOffice we must buy MS Office 2013.
Not sure what Eike is saying but is it is indeed caused by M$ not supporting ODF 1.2 properly it would be NOTOURBUG. Eike can you set this bug to either confirmed NEW or NOTOURBUG?
Set status to NotOurBug due to comment #1 Best regards. JBF
*** This bug has been marked as a duplicate of bug 56209 ***