Apache OpenOffice (AOO) Bugzilla – Issue 97242
Failure to import XML from Mobile Excel xlsx (mobile office)
Last modified: 2023-02-02 18:31:55 UTC
I am unable to open a file generated by Mobile Excel. The file is Excel 2007 XML format with an XLSX extension, but there is clearly some non-standard format when these files are generated by Mobile Excel. When trying to open the file OO asks for a template (which it doesn't normally do with XLSX files). I choose Excel 2007 XML format. OO responds with a "General input/output error". If I send the file elsewhere for translation to an XLS or (standard) XLSX file format, OO opens it without asking for a template, any error message or any problem. The only exception to that last statement is if I try to use the opensource commandline tool odfconverter. That produces an XLS file which OO has no problem opening, but the file is blank. I have put this down as a calc issue as that is what I have tested, but I imagine that it would affect the other mobile office components.
*** Issue 96000 has been marked as a duplicate of this issue. ***
Wrong Priority Its a crossplattform and crossos bug Set keyword: oooqa A Bugdoc you can find here (http://www.openoffice.org/nonav/issues/showattachment.cgi/57799/Classeur1.xlsx) My commen: Tested with Mac OS X 10.5.2 and a OOo 3.1 You moast simply choin the Excel 2003 XML Filter, and the File should load. Please try this, and give me a report. Thanks
Configuration - WIN XP SP2, OOO 3.1(also checked in OOO 3.0.1). It's not working. On OOO 3.0.1 it was completely identical to the original description. On OOO 3.1(recently installed) when I'm trying to open my own or Classeur1.xlsx file it doesn't even ask to choose a format, but simply starts Calc with empty Untitled file. So the issue remains unsolved.
This issue, or a variation of it, still exists. I am on Mac OS X 10.6.4 With OOo 3.2.1 (OOO320m18 build 9502) and also 3.2.1 on linux (Cent OS 5) installed from RPMS. xlsx files created with recent versions of Excel Mobile are not recognized automatically and instead prompt for the filter to use to open. Choosing Microsoft Excel 2007 XML will then open the file and it appears to work normally. This is okay as long as you know what to pick from the list, but is an issue when trying to work the the API calls to open and manipulate files. Specifying the filter name through the API does not seem to allow the file to be open the same as choosing it when manually opening the file does.
Created attachment 71506 [details] Example xlsx file saved from the Windows Mobile version of Excel which OOo will not open automatically
Attachment opens OK in Excel 2010. Calc shows Filter Selection dialog. Selecting Microsoft Excel 2007 XML gives General Error. Rev. 1523756 Win 7
When unzipped and _rels/.rels is examined: <?xml version="1.0" encoding="UTF-16" standalone="yes"?> <Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"> <Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="/xl/workbook.xml"/> </Relationships> the <Relationship> element has a "Target" attribute of "/xl/workbook.xml". The leading slash is unexpected and AOO used to break on it. It opens successfully in the latest Git, because this was fixed recently in bug 117672. Resolving duplicate. Thank you for your bug report and sample document :-). *** This issue has been marked as a duplicate of issue 117672 ***