I have a LibreOffice Calc file that I use every day. I keep it as an ODF (.ods extension) file.
If I open it in Microsoft Office AS AN ODF FILE (not saved as .xls or .xlsx), I receive the following warning: "Excel found unreadable content in 'myfile.ods'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes." When I click "Yes," the document opens fine with one important differences: All formulas are removed and only their last result is in the cells that had those formulas. This is a known incompatibility between LO/OO.o. Microsoft supports ODF 1.1 and ODF 1.1 has no specification of formulas. So Microsoft implements and recognizes Excel formulas in ODF 1.1 Spreadsheets. Microsoft ODF 1.1 support does not recognize OpenFormula formulas, introduced in ODF 1.2 and now produced, I believe, by the latest versions of LibreOffice if not all of them. It is my understanding that Microsoft Excel support for ODF 1.1 Spreadsheets also doesn't accept the OpenOffice.org-specific formulas used by OpenOffice.org Calc in ODF 1.1 documents. But the message from Microsoft Excel, if any, might not be the same for that case. I must try it. I think the reverse is also true: that OO.o/LO do not recognize or at least don't promise to correctly process the formulas that Microsoft Excel produces in ODF 1.1 documents. (Note that I am not talking about .xls and .xslx documents, but ODF 1.1 .ods documents produced by current Microsoft Excel versions.) - Dennis -----Original Message----- From: Marcello Romani [mailto:[email protected]] Sent: Wednesday, September 07, 2011 01:00 To: [email protected] Subject: Re: [libreoffice-users] Calc corrupted an Excel xlsx file, should I report a bug? Il 07/09/2011 09:56, Roelof Oomen ha scritto: > I got a corrupted Excel xlsx file when I opened and subsequently saved it > using LibreOffice Calc. When I open it in Excel the message is "Excel found > unreadable content [...]", but opening it again in Calc does not produce any > errors. > > Should I file a bug? Or is someone interested in the file in order to improve > the xlsx saving abilities of Calc? > > Cheers, > Roelof > Are you sure you /really/ saved it with Excel format, or did you just type the xlsx extension in the save as dialog (I ask because I did that same mistake once) ? -- Marcello Romani -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
