<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN: General Error opening Excel 2003/XML file"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114291">114291</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN: General Error opening Excel 2003/XML file
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.7.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>jeanmarcranger@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>