Apache OpenOffice (AOO) Bugzilla – Issue 87105
Write Error on export to Microsoft Excel 2003 XML format
Last modified: 2013-08-07 15:14:53 UTC
Exporting this ods file to Microsoft Excel 2003 XML format causes this error message to pop up. Error saving the document kacer_0208: Write Error. The file could not be written.
Created attachment 52140 [details] example file
confirmed
On 2.2.1 it runs fine, 2.3 and 2.4 are affected.
Jurino: There is somewhere a endless loop, I activated the debug: Under toolbar - OPTIONS - JAVA EnvironmentVariable add, e.g. -DXSLTransformer.statsfile=E:\offices\xslt_debug_xsltfilter08.txt And the output will be written into the file. Someone have to take a look into it, usually the transformation works standalone as well, when instead of the ZIP the FLAT XML file is being used as input. more information about this can be found on the xml dev mailinglist. Furthermore, by adding some notes xsl:message into the source code or using an XSLT debugger the issue can be found. The Excel2003 filter is unfortunately no longer on my prio list, as OOXML has become its successor, somebody else have to help out. Thanks for pointing out the problem, nevertheless.. Svante
I've tried to save the ods file in the 2003 XML format and it still doesn't work (OO 3.0 beta) :(.
I am sorry, I am no longer working on this format. Changed target to Office later. Is anybody able to take this over? And/or provide a patch for this problem? Thanks in advance, Svante
Just tested it on OpenOffice production version and it still does not work. Endless loop.
We need someone of the community to take this over! Any volunteers?
The error is triggerd, when there are some empty rows which has to be considered. In detail: When you have 3 and more empty rows between to entries: 123 234 or when you have 4 and more empty rows after entries, which have a formatting like borders or background color and therefore have to be considered. In the example file there are the empty rows 23 to 47 with borders. Delete this rows and the file will save to Excel 2003 XML format.
*** Issue 94787 has been marked as a duplicate of this issue. ***
*** Issue 96005 has been marked as a duplicate of this issue. ***
Bug still exists in version 3.0 of OpenOffice. Microsoft Excel 2003 XML export is only rarely usable.
Yes, we need a developer, who will contribute his work on this. The status is set to "OOo PleaseHelp".. Regards, Svante
This appears to probably be the xalan 2.7.1 issue also referenced here: http://www.openoffice.org/issues/show_bug.cgi?id=99097 http://www.openoffice.org/issues/show_bug.cgi?id=99703 And here: http://mail-archives.apache.org/mod_mbox/xml-xalan-dev/200802.mbox/<7365434.1201876156390.JavaMail.jira@brutus>
Sorry after more research this is almost certainly not the xalan issue I mentioned before...
I believe this issue is probably caused by using system saxon, the internal saxon has patches to it that allow it to work with the stylesheets in OOo. There should be a configure warning to warn users not to build with system saxon until the patches have been integrated upstream and/or convert the OOo xsl stylesheets to XSLT 2.0 which would probably also resolve this problem.
I have the same issues even in ooO-dev 3.2 someone, fix it please
I reported about same issue on https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/452876. On ubuntu 9.04 i found the solution good for me: 1. Remove all openoffice* and sun-java* packages. 2. Go to the site http://download.openoffice.org/other.html#ru 3. Choose "Include the Java JRE ..." 4. Download version suitable for me: (Russian 3.1.1) (Linux 32-bit DEB) or http://openoffice.bouncer.osuosl.org/?product=OpenOffice.org&os=linuxinteldeb&lang=ru&version=3.1.1 5. Unpack downloaded file 6. Launch file update in unpacked directory Hope, this helps somebody.
Created attachment 71412 [details] example file - "don't save as xml.ods" & "save as xml.ods"
Does not save to xml if cell A1 is empty and data is scattered on the sheet. For example file: save to xml “save as xml.ods” and does not save to xml “don't save as xml.ods”.