Problem description: LibreOffice is ignoring Excel 2003 XML files. Steps to reproduce: 1. Put Excel 2003 XML file on desktop 2. Open (double click) 3. You will see xml code instead document There is workaround. You need to start LO and then choose Open->File type Excel 2003 XML->Select file. This works well. Current behavior: Not working. Expected behavior: Should work. Excel 2003 XML is still used. Operating System: Windows 7 Version: 4.1.1.2 release
Hi Michal, please try again using LO 4.1.2.3 & resetting user profile. If it works, please change status to RESOLVED WORKSFORME. Otherwise, attach your sample file here & change status to UNCONFIRMED.
I think this is a dup *** This bug has been marked as a duplicate of bug 70100 ***
It can't be a duplicate of bug 70100, as xml detection code is not related in any form to excel detection code. I can't reproduce this bug on Windows 7 (32-bit) using 4.1.1.2 & 4.1.3.1 with a valid xml file, only with a non-valid one. So I'll mark this bug as WORKSFORME.
still an issue in Version 4.1.3.2 on Xenapp 6.5HRP2 (Windows 2k8R2) and Windows 8.1 Desktop. Thanks Michal for your workaround. But in my opinion this is a downgrade of the old behavior. The parser doesn't recognize it right. Bug 70100 looks similar, but is not the same, they are talking about Excel 2003 xls files, not those Excel 2003 xml files.
(In reply to comment #4) > still an issue in Version 4.1.3.2 on Xenapp 6.5HRP2 (Windows 2k8R2) > and Windows 8.1 Desktop. @RS: Hi, please attach the affected file.
Created attachment 90300 [details] test XML file This is a anonymized test file.
Here is an interesting additional information. At first i edited(only field content to anonymize) the original file with TextPad Editor and saved it. After this i could open the file by selecting "Open with -> LibreOffice Calc" in the context menu. Then i tried to anonymize the original file by using the windows editor which worked and LibreOffice Calc still can't open the file out of the Windows Explorer (as the original one). What is wrong with MS Excel 2003 XML Output? Thank you for investigating. =)
@RS: The attached file is UTF-8 with BOM. Removing the BOM makes LO detect the file correctly. It's the same observation as at Bug 46262 comment 9. The detection fails in filter/source/xmlfilterdetect/filterdetect.cxx in isXMLStream function. There is no handling of BOM. *** This bug has been marked as a duplicate of bug 46262 ***
Maxim, please not this fast, the other thread is dead since 2012. This BUG is new and LO 4.0.4 opened the file correctly. We got those files from a big marketing agency in germany and i'm sure we are not the only company which has to deal with UTF-8 BOM XML files. Regards, Ralf
(In reply to comment #9) > Maxim, please not this fast, the other thread is dead since 2012. Sorry, but those are the rules of this bug tracker. A new bug should be closed as a duplicate of the older. See https://wiki.documentfoundation.org/QA/Bugzilla/FAQ#How_to_Mark_a_Bug_as_Duplicate Anyway, I submitted a patch for Bug 46262 which should fix also your file detection: https://gerrit.libreoffice.org/#/c/6942/