Apache OpenOffice (AOO) Bugzilla – Issue 7009
Xcl Imp/Exp: Various conversion issues
Last modified: 2013-08-07 15:12:27 UTC
When opening a large spreadsheet created and saved by Microsoft Office97 (MO) with a size of eg 3071 KB, and saving this with OpenOffice 1.0.1 (OO), the resulting size is doubled to 6158 KB in this case. When reopening the OO spreadsheet with MO, I get a Name conflict for Built-in name Print_Area, many calculated values are in error because of the parenthese as in formula [=$K$16+G346*($J$16)]. When opening an OO saved spreadsheet with OO as wel as opening the original MO spreadsheet in OO, my disk is being used constantly and the time I have to wait is enormously, much much longer than doing the same with MO (more than 5 minutes versus much less than 1 minute). A column width of eg "8" in MO was translated to "1.67cm" in OO and when saved and reopened in MO then it was reduced to "7.86". PS: If you want you may split up this issue in several issues ...
Input file in MO format as well as outputs in MO gormat and in OO format are temporarily available in http://www.mvdw.com/testoffice/
1) Size doubled on export: Known, see issue 194 2) Name conflict: fixed in OOo1.0.2 (or 1.0.3), see issue 2394 3) Parentheses in formulas: Known, see issue 3724 4) Performance: Known, see issue 3132 5) Column width: Known, see issue 3006 As you can see, it's not necessary to split this bug :-) I will keep this issue open so I will not forget to test the fixes with your document.
Started
target->OOoLater
p3