Apache OpenOffice (AOO) Bugzilla – Issue 194
Xcl Exp: Default style of all cells
Last modified: 2013-08-07 15:15:02 UTC
The attached file contains a small spreadsheet and is saved by oppen office in 34k. When saved as Excel 97/2000 it becomes 16+ Megabytes. I believe that it is because it has been formatted white text on black background. I suspect that it has formatted every cell from A1 to IV32768 explicitly, where as in the openoffice format, and in excel, it has been more intelligent.
Created attachment 44 [details] openoffice (calc) file
Workaround: There is a better way to create such a file: open a new spreadsheet, press F11 to open the Stylist, make a right click on DEFAULT and choose MODIFY. Now you can change the default cellstyle to a black background and a white font.
found several probs concerning these area (also in import) which must be fixed asap
Achieved level of 'compression' is less than Excel but much better than previous version. (e.g. 16MB for one sheet reduced to 1.5MB) This shouldn't be the maximum of what one could do in general. But the differences in the document structure (OOo Calc <-> Excel) are to big to implement the complete Excel behaviour in a short time -> has to be done sometime in the future.
Fixed, but failed.
The original fix doesn't work anymore.
Will be done with implementation of export of default column and default row formatting.
*** Issue 6796 has been marked as a duplicate of this issue. ***
target->OOo2.0
Problem in attached document: Border around entire sheet, forces export of all 16M cells, because last row and last column are different from all other cells. Not fixable, missing core functionality: Calc has to store default row/column formatting. target back to OOo2.0
*** Issue 11696 has been marked as a duplicate of this issue. ***
.
According to the OpenOffice.org roadmap (http://tools.openoffice.org/releases) this issue was retargeted to OOo Later.
Finally...... Fixed in src680/dr20, will be integrated in OOo 2.0. Exported file size reduced from 17MB to 8KB.
Latest optimizations reduce file size from 8192 bytes to 7680 bytes.
target -> OOo 2.0
reopened
back to QA
fixed again
verified in internal build cws_dr20
Found integrated in master src680m54 using Linux and Windows build