Bug 42906 - Unreadable content Libreoffice 3.4.x /Excel 2010
Summary: Unreadable content Libreoffice 3.4.x /Excel 2010
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.4 release
Hardware: x86-64 (AMD64) Windows (All)
: high critical
Assignee: Not Assigned
Depends on:
Reported: 2011-11-14 02:58 UTC by bones
Modified: 2012-09-07 21:42 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:

Example created using LO 3.4.3. Will fail when opening with Excel 2010 (15.78 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2011-12-01 14:02 UTC, Damon

Note You need to log in before you can comment on or make changes to this bug.
Description bones 2011-11-14 02:58:09 UTC
If I create with LibreOffice 3.4.4 a new .ods file and open it with excel 2010 excel tells me, that unreadable content has been found. 

If I create a new file with LibreOffice 3.3.4, there is no problem!

Step by step:
1. create a new .ods file
2. save the file
3. close LO
4. open the .ods file with Excel 2010
5. Excel 2010: Excel found unreadable content in <filename>
6. same problem with .xlsx (created by LO)
Comment 1 Regina Henschel 2011-11-19 15:23:23 UTC
I think, for the ods file type not the export of LibreOffice is wrong, but the import by Excel. The ods files open without any error in Gnumeric.

It is not worth to look, whether the export to ODF1.2 can be changed to allow opening in Excel without errors, because Excel drops all functions anyway and accepts only functions in its own namespace but not in the default open formula grammar.

The error in the xlsx file is already tracked in bug #fdo35062.
Comment 2 Damon 2011-12-01 14:02:03 UTC
Created attachment 54042 [details]
Example created using LO 3.4.3. Will fail when opening with Excel 2010

I same seeing the same behavior in 3.4.3 that jens outlined.

The attached file will cause errors when opening with Excel 2010.

Google Docs opens this fine, so the theory that Excel does not support the standard may be valid. I did not see this problem in OOO-dev working with Excel 2010.
Comment 3 Damon 2011-12-01 15:09:08 UTC
As jens describes, this behavior is not repeated in 3.3.4; it is seen in 3.4 only.

I followed the same steps as before, and I can interop between 3.3.4 and MS Excel 2010 with no errors.
Comment 4 Markus Mohrhard 2011-12-04 07:58:08 UTC
This is not a bug. As Regina already mentioned Excel can't deal with ODF 1.2 and therefore is an Excel bug and not a Libreoffice bug. The output from Libreoffice 3-4 is standard conform.
Comment 5 Damon 2011-12-05 07:49:20 UTC
I do not see whose fault it is as mattering much.

You may be complying strictly with ODF 1.2, but it is obvious that something in your output changed when going from version 3.3 to 3.4 that is causing Excel to choke.

Everyone knows that Microsoft is horrible at following standards, so I suspect you are correct, it's their bug.

But the important part here is that whatever you implemented in version 3.4 is breaking the interoperability with Excel. Find a workaround for this, such as the option of disabling it or saving into ODF version 1.1, which I did not see as an option.
Comment 6 Bruno 2012-09-07 21:42:25 UTC
For anyone facing this problem, there is an option to save as ODF 1.0/1.1 instead of 1.2 in OpenOffice 3.4/LibreOffice 3.5.

In Tools -> Options -> Load/Save -> General, choose the ODF format version.