Apache OpenOffice (AOO) Bugzilla – Issue 71689
Save large document as Excel XML
Last modified: 2013-08-07 15:12:27 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
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
Bug remain in OO 2.1 Fileformat: Microsoft Excel 2003 XML (.xml) (file extension: .xml)
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.
smaller files can be saved. cannot create attachments but posted the file here: http://www.cs.umu.se/~c01jpn/65k_no_attributes.xls
Confirming with 2.3m211 on WinXP - as described. Progress bar goes to almost an end and then I get error message.
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.
Hi Swante, one for you I think. Frank
Created attachment 46235 [details] Testdocument
Dear developers, any progress with this issue?
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
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.