Issue 112592 - .xls opens empty or in Writer
Summary: .xls opens empty or in Writer
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-06-22 08:52 UTC by kpalagin
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description kpalagin 2010-06-22 08:52:32 UTC
(Confidential sample file be sent to fst).

The file is Excel 2003 XML. If you double-click it it will open in Writer. If
you explicitely specify "Excel 2003 XML" the file opens empty. The same also
happens in m75.
Comment 1 frank 2010-06-22 10:06:32 UTC
Hi Kirill,

used 3.2.1 and tried to open it.
Doubleclick on the file results in text import dialog which is pretty well Ok as
the filter detection finds out it's not an XLS binary file.

Tried to open it via Open dialog and selecting XML as filter and the file opened
blank as you've found out.

Renamed the file to XML and double clicked. IE starts and tell me that there is
a Hex value which makes it impossible to render the file correctly.

Send the XML file to XML Notepad from Microsoft and got the same warning.

Opened the file with Excel 2k3 and it worked well. Saved it under a new name as
XML file and put it back into XML Notepad and OOo3.2.1 . Both opened the file
fine and also OOo shows the content.

Therefore the conclusion is: The file itself is broken in it's structure and
therefore can't be displayed correctly by Calc.

So Issue is invalid.

Comment 2 frank 2010-06-22 10:06:55 UTC
closed invalid
Comment 3 kpalagin 2010-06-22 11:00:19 UTC
as the file can be opened in Excel we should be able to open it too.
Please reconsider closing this issue.
Comment 4 daniel.rentz 2010-06-22 12:42:23 UTC
Sounds as if the file contains invalid characters thus the XML parser exits.
Excel is known to not care so much about validity of XML streams. We may fix
this in the future, so I may take this issue with target "Later". A patch would
be appreciated.
Comment 5 kpalagin 2010-06-23 15:03:44 UTC
thanks a lot! I will reopen the issue then.

Comment 6 gang65 2010-06-24 09:30:15 UTC
Attach some sample file, which cause trouble.