Issue 71689 - Save large document as Excel XML
Summary: Save large document as Excel XML
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.0.2
Hardware: PC Windows XP
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2006-11-18 13:19 UTC by jopa81
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

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

Testdocument (919.01 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-06-25 14:58 UTC, frank
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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 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.


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

cannot create attachments but posted the file here:

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.

Comment 8 frank 2007-06-25 14:58:33 UTC
Created attachment 46235 [details]
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

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

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.