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
The file open like text code, not like regular spreadsheet
Open the file like a spreadsheet
Reproducible: Didn't try
User Profile Reset: Yes
OpenGL enabled: Yes
Version: 220.127.116.11 (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
with a capital S
If you change the two occurrences to
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
> 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.