Description: I have does the installation of LibreOffice on my organization and they can open all documents except one, a .xls file (SpreadsheetML, XML Spreadsheet 2003, or XMLSS) who it´s generated from a third party CRM and i can´t change de code. I had googling that for more than two days and i can´t find a solution for that, that it´s a very important file for the organization. the file code it´s ok for Microsoft Office. Thanks in advance. Steps to Reproduce: 1.Open the file 2.Select codification ISO-8859-1 3.Accept Actual Results: The file open like text code, not like regular spreadsheet Expected Results: Open the file like a spreadsheet Reproducible: Didn't try User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Version: 5.4.4.2 (x64) Build ID: 2524958677847fb3bb44820e40380acbe820f960 CPU threads: 4; OS: Windows 6.19; UI render: default; Locale: en-US (en_US); Calc: group User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36
Created attachment 139382 [details] This is the truble file I add the file as attachment.
*** This bug has been marked as a duplicate of bug 68742 ***
The empty lines are not the only problem in that file. If you remove the empty lines and the spaces before the processing instructions, then the file opens in Calc, but it is empty. The additional problem is, that it uses "urn:schemas-microsoft-com:office:Spreadsheet" with a capital S If you change the two occurrences to "urn:schemas-microsoft-com:office:spreadsheet" the file opens in Calc with content.
(In reply to Regina Henschel from comment #3) > The empty lines are not the only problem in that file. ... > The additional problem is, that it uses > "urn:schemas-microsoft-com:office:Spreadsheet" > with a capital S Thank you Regina! You are absolutely right. And that is another reason why I generally dislike the idea to relax our parser to accept wrong syntax: if a generator does it wrong, there will be no end to different ways in which the output will be wrong.