Apache OpenOffice (AOO) Bugzilla – Issue 112592
.xls opens empty or in Writer
Last modified: 2013-08-07 15:12:27 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.
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. Frank
closed invalid
Frank, as the file can be opened in Excel we should be able to open it too. Please reconsider closing this issue.
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.
Daniel, thanks a lot! I will reopen the issue then.
Attach some sample file, which cause trouble.