Issue 97242 - Failure to import XML from Mobile Excel xlsx (mobile office)
Summary: Failure to import XML from Mobile Excel xlsx (mobile office)
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.0
Hardware: All All
: P3 Trivial with 4 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
: 96000 (view as issue list)
Depends on:
Blocks:
 
Reported: 2008-12-14 10:02 UTC by oalexmay
Modified: 2013-09-20 08:18 UTC (History)
5 users (show)

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


Attachments
Example xlsx file saved from the Windows Mobile version of Excel which OOo will not open automatically (4.19 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2010-08-31 19:53 UTC, benlevy
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description oalexmay 2008-12-14 10:02:49 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.
Comment 1 Raphael Bircher 2009-05-06 07:55:13 UTC
*** Issue 96000 has been marked as a duplicate of this issue. ***
Comment 2 Raphael Bircher 2009-05-06 08:15:31 UTC
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
Comment 3 daemoned 2009-05-22 09:29:32 UTC
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.
Comment 4 benlevy 2010-08-31 19:51:59 UTC
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.
Comment 5 benlevy 2010-08-31 19:54:00 UTC
Created attachment 71506 [details]
Example xlsx file saved from the Windows Mobile version of Excel which OOo will not open automatically
Comment 6 Edwin Sharp 2013-09-20 08:18:20 UTC
Attachment opens OK in Excel 2010.
Calc shows Filter Selection dialog. Selecting Microsoft Excel 2007 XML gives General Error.

Rev. 1523756 Win 7