Issue 194 - Xcl Exp: Default style of all cells
Summary: Xcl Exp: Default style of all cells
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 609
Hardware: PC Windows ME
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@www
: 6796 11696 (view as issue list)
Depends on:
Reported: 2000-11-28 08:49 UTC by issues@www
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

openoffice (calc) file (34.00 KB, application/octet-stream)
2003-12-06 14:52 UTC, issues@www
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description issues@www 2000-11-28 08:49:24 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.
Comment 1 issues@www 2000-11-28 08:50:07 UTC
Created attachment 44 [details]
openoffice (calc) file
Comment 2 oc 2000-11-28 10:42:26 UTC
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.
Comment 3 gunnar.timm 2001-01-30 14:22:47 UTC
found several probs concerning these area (also in import) which must be fixed 
Comment 4 gunnar.timm 2001-04-06 13:37:06 UTC
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.
Comment 5 oc 2002-01-14 10:50:09 UTC
Fixed, but failed.
Comment 6 oc 2002-01-14 10:51:19 UTC
The original fix doesn't work anymore. 
Comment 7 daniel.rentz 2002-01-29 09:44:41 UTC
Will be done with implementation of export of default column and default row 
Comment 8 daniel.rentz 2002-08-06 17:50:51 UTC
*** Issue 6796 has been marked as a duplicate of this issue. ***
Comment 9 daniel.rentz 2003-01-13 16:03:41 UTC
Comment 10 daniel.rentz 2003-02-24 15:25:01 UTC
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
Comment 11 daniel.rentz 2003-02-25 09:39:40 UTC
*** Issue 11696 has been marked as a duplicate of this issue. ***
Comment 12 daniel.rentz 2003-09-19 14:59:13 UTC
Comment 13 oc 2003-09-22 10:46:38 UTC
According to the roadmap
( this issue was retargeted to
OOo Later.
Comment 14 daniel.rentz 2004-08-12 13:30:18 UTC

Fixed in src680/dr20, will be integrated in OOo 2.0.

Exported file size reduced from 17MB to 8KB.
Comment 15 daniel.rentz 2004-08-16 16:12:09 UTC
Latest optimizations reduce file size from 8192 bytes to 7680 bytes.
Comment 16 daniel.rentz 2004-08-20 09:51:36 UTC
target -> OOo 2.0
Comment 17 daniel.rentz 2004-08-23 16:26:21 UTC
Comment 18 daniel.rentz 2004-08-23 16:27:22 UTC
Comment 19 daniel.rentz 2004-08-23 16:30:20 UTC
back to QA
Comment 20 daniel.rentz 2004-08-23 16:36:19 UTC
fixed again
Comment 21 oc 2004-08-30 13:32:47 UTC
verified in internal build cws_dr20
Comment 22 frank 2004-10-06 10:28:22 UTC
Found integrated in master src680m54 using Linux and Windows build