|
Authored by: Bernard on Tuesday, May 08 2012 @ 09:00 PM EDT |
And the ODF support is woeful.
Try to open an ODF file, and you get lots of nasty warning
messages about the file is damaged, and has to be
repaired.
And by "repair", they mean, for example, stripping the
formulae out of your spreadsheet, and replacing them with a
plain text version of the formula results.
I made up a simple spreadsheet in LibreOffice Calc, with 5
values in one column, and the next column contained a
formula multiplying the value by 23.5.
Here's the XML from the ODF file:
<table:table-cell office:value-type="float"
office:value="23.5" table:formula="of:=[.A4]*23.5">
Excel 2010 displays the "office:value" value, but dumps the
formula.
You know, to "correct the errors" in the "corrupt"
spreadsheet...
It also displays warning messages about corrupt files if you
open an OOXML file created in LibreOffice.
The plain .xls file is even better: "Office has detected a
problem with this file. Editing it may harm your computer."
Then, when you go to shut down Excel, it says "Help
Microsoft improve Office" by sending an error report to
Microsoft that contains the entirety of the file you were
trying to open. It tried to do that to me a week or two
back with a file that Excel couldn't open that contained a
lot of sensitive business information. LibreOffice had no
trouble opening the file, luckily. (It was a .xls file)
[ Reply to This | Parent | # ]
|
|
|
|
|