Bug 82493

Summary: Excel 2003 XML files cannot be opened anymore
Product: LibreOffice Reporter: Anton Derbenev <anticode+bugs.freedesktop.org>
Component: filters and storageAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED INVALID    
Severity: normal CC: momonasmon
Priority: medium    
Version: 4.3.0.4 release   
Hardware: x86 (IA32)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Excel 2003 XML file from bank, cannot be opened in 4.3.0.4, can be in 4.1.6

Description Anton Derbenev 2014-08-12 06:38:19 UTC
Created attachment 104468 [details]
Excel 2003 XML file from bank, cannot be opened in 4.3.0.4, can be in 4.1.6

In previous versions (4.1.6 works for sure), I've been able to open Office 2003 files, received from my bank.

Though I had to convert its encoding (originally they are in cp1251, and LO4.x only supported UTF-8), I've done that with special script, and it didn't take much time.

But with 4.3.0.4 that's not the case, LO simply refuses to recognize that format, and opens it as plaintext, or in plaintext parse mode if I open it as a sheet.

Example XMLs attached.

It's getting worse and worse, as with 3.x I was able to open this files as received, without conveting encoding. Now I can't open them at all, and have to fall back to 4.1 (4.2 seems too buggy for me).
Comment 1 Maxim Monastirsky 2014-08-12 07:04:28 UTC
Hi Anton,

(In reply to comment #0)
> Though I had to convert its encoding (originally they are in cp1251, and
> LO4.x only supported UTF-8), I've done that with special script, and it
> didn't take much time.
It's fixed for the upcoming 4.3.1 release, see Bug 63756.

> But with 4.3.0.4 that's not the case, LO simply refuses to recognize that
> format, and opens it as plaintext, or in plaintext parse mode if I open it
> as a sheet.
Can't reproduce. Tested under Windows 7 and Fedora 20.
Comment 2 Maxim Monastirsky 2014-08-12 07:48:04 UTC
Anton: Could you please run the 4.3 installation, and make sure that you have selected XSLT filters?
Comment 3 Anton Derbenev 2014-08-12 08:23:52 UTC
okay, probably my failure. Did not install XSLT, but neither I installed XSLT when installed 4.1.6.
Comment 4 Anton Derbenev 2014-08-12 08:27:59 UTC
works if XSLT filters are installed with LO.