Issue 71689

Summary: Save large document as Excel XML
Product: Calc Reporter: jopa81 <johannes.palmgren>
Component: save-exportAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: da.blayde, issues, kpalagin
Version: OOo 2.0.2Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Testdocument none

Description jopa81 2006-11-18 13:19:26 UTC 
Saving large documents as Excel XML yields an error.

errordialog say:
Error saving the document: X
Write error.
The File could not be written. >OK<

The file has ~65k rows and 4-6columns
Comment 1 olly600 2006-12-28 12:00:19 UTC 
Can you:
1. Download and install the latest issue of OpenOffice.org(currently version 2.1).
2. Try this issue out with the latest version and confirm whether the error
still occurs.
3. Make it clear what file extension you are trying to save the file as i.e.
xls, xhtml
Comment 2 jopa81 2006-12-30 11:35:23 UTC 
Bug remain in OO 2.1

Fileformat: Microsoft Excel 2003 XML (.xml) 
(file extension: .xml)
Comment 3 olly600 2007-01-10 10:09:30 UTC 
Can you confirm that you can save a smaller document as an Excel XML file using
OOo 2.1.

Do you have an example spreadsheet for the large document? If so can you attach it.

Thanks.
Comment 4 jopa81 2007-01-10 11:39:07 UTC 
smaller files can be saved.

cannot create attachments but posted the file here:
http://www.cs.umu.se/~c01jpn/65k_no_attributes.xls
Comment 5 kpalagin 2007-05-10 14:55:01 UTC 
Confirming with 2.3m211 on WinXP - as described.
Progress bar goes to almost an end and then I get error message.
Comment 6 blayde 2007-06-20 01:16:09 UTC 
Everything is the same for me, but on both Ubuntu (OO.o 2.2.0) and Windows XP
Pro (OO.o 2.2.1). Can't post file because of it's sensitive nature.
Comment 7 frank 2007-06-25 14:57:07 UTC 
Hi Swante,

one for you I think.

Frank
Comment 8 frank 2007-06-25 14:58:33 UTC 
Created attachment 46235 [details]
Testdocument
Comment 9 kpalagin 2008-01-18 09:13:11 UTC 
Dear developers,
any progress with this issue?
Comment 10 svante.schubert 2008-01-18 11:02:38 UTC 
I am sorry, this filter was once created by myself, but I was shifted to other
projects.

The filter is now opensource and have to be improved by the community.

Svante
Comment 11 jmichae3 2010-05-18 11:22:31 UTC 
I have similar problems except with a much smaller file.  the problem is that
the cell index entries in the xml file are quite numerous and very duplicated,
sometimes 299 times for one formula cell, thus generating huge files.  I suspect
that the result of all this is hitting some sort of 32-bit integer/2GiB barrier.

check the code base.  I am a programmer, and I wrote programs that write multiGB
files on purpose as test files (my program is called createfile).  my computer
takes writes at about 1GB/minute at full blast, so for a 2GB limit it is about 1
minute 25 seconds, timed.  OOo is taking about 2-4 times as long as that to write.
much of that time could be spent processing or in overhead with java VM or the
app itself.

but there's a number of bugs in the output routines.