Issue 194 - Xcl Exp: Default style of all cells
Summary: Xcl Exp: Default style of all cells
Status: CLOSED FIXED
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
URL:
Keywords:
: 6796 11696 (view as issue list)
Depends on:
Blocks:
 
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: ---

Attachments
openoffice (calc) file (34.00 KB, application/octet-stream)
2003-12-06 14:52 UTC, issues@www 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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 
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.
Comment 3 gunnar.timm 2001-01-30 14:22:47 UTC 
found several probs concerning these area (also in import) which must be fixed 
asap
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 
formatting.
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 
target->OOo2.0
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 OpenOffice.org roadmap
(http://tools.openoffice.org/releases) this issue was retargeted to
OOo Later.
Comment 14 daniel.rentz 2004-08-12 13:30:18 UTC 
Finally......

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 
reopened
Comment 18 daniel.rentz 2004-08-23 16:27:22 UTC 
reopened
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