Issue 11696 - export to .xls crashes
Summary: export to .xls crashes
Status: CLOSED DUPLICATE of issue 194
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.2
Hardware: PC Windows XP
: P2 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-02-20 22:35 UTC by Unknown
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

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

Attachments
export to .xls fails (12.97 KB, application/octet-stream)
2003-02-20 22:36 UTC, Unknown 		no flags Details
same as original - without redundant formatting (12.51 KB, application/octet-stream)
2003-02-25 09:36 UTC, daniel.rentz 		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 Unknown 2003-02-20 22:35:46 UTC 
When I try to save the attached .sxc as .xls Calc hangs and doesn't react to 
anything (no redraw anymore) and a huge .tmp file is produced (>90 MB). 
Reproducable with 1.0 and 1.0.2.
Comment 1 Unknown 2003-02-20 22:36:53 UTC 
Created attachment 4816 [details]
export to .xls fails
Comment 2 daniel.rentz 2003-02-25 09:36:07 UTC 
Created attachment 4888 [details]
same as original - without redundant formatting
Comment 3 daniel.rentz 2003-02-25 09:39:44 UTC 
There are all cells hard-formatted with font size 10pt -- except the
cells in the very last column. This causes the export filter to export
each and every cell in the range A1:IU31939 -- in all sheets.

The reason may be: First the entire sheet was selected, then
hard-formatted with a font size. After that, a column has been
deleted. This inserts a default formatted column at the end of the sheet.

The problem: the Excel export filter thinks the cells in the last
column are the row default, and therefore exports all other cells in
the row, because they are different from the last cell. This is a
known problem, see issue 194.

Workaround: In all sheets:
- select the columns Q:IV, delete these columns (entire columns, not
the cells)
- select the rows 25:32000, delete these rows (entire rows, not the cells)
This delets the hard formatting.

I will attach a copy of your original file, without the redundant
formatting, to this bug. If you export this file to Excel, it will
take ~45kByte.

*** This issue has been marked as a duplicate of 194 ***
Comment 4 oc 2003-03-10 12:24:33 UTC 
Closed because duplicate