[Libreoffice-bugs] [Bug 114291] New: FILEOPEN: General Error opening Excel 2003/XML file

Wed Dec 6 18:59:48 UTC 2017

https://bugs.documentfoundation.org/show_bug.cgi?id=114291

            Bug ID: 114291
           Summary: FILEOPEN: General Error opening Excel 2003/XML file
           Product: LibreOffice
           Version: 5.3.7.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jeanmarcranger at gmail.com

Description:
The soon-to-be-attached file fails to open with a "General Error"/"General
input/output error" message.
File comes from the discount broker branch of Canada's Royal bank. They've been
notified of the error but claims that the file opens successfully in Excel 2013
and may or may not fix it.
Upon investigation, I found that the file contains French symbols encoded as
Windows-1252, but fails to state so in the header - therefore Calc assumes that
content is UTF-8 and fails.
Modifying the file by replacing the original <?xml version="1.0"?> header by
<?xml version="1.0" encoding="Windows-1252"?> fixes the issue.
Given that this can be considered a malformed file, I'm not sure whether it
should be addressed or not.
Tested on 5.3.7.2 release. Not tested on newer pre-release versions.

Steps to Reproduce:
Double click file to open it.

Actual Results:  
"General Error"/"General input/output error"

Expected Results:
File opens.

Reproducible: Always

User Profile Reset: No

Additional Info:

User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/62.0.3202.94 Safari/537.36

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171206/cebae121/attachment.html>