<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:momonasmon@gmail.com" title="Maxim Monastirsky <momonasmon@gmail.com>"> <span class="fn">Maxim Monastirsky</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN MS Excel 2003 XML fails when having double UTF-8 BOM"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137015">bug 137015</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>FILEOPEN MS Excel 2003 XML fails when header includes <?xml version="1.0"?>
</td>
<td>FILEOPEN MS Excel 2003 XML fails when having double UTF-8 BOM
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN MS Excel 2003 XML fails when having double UTF-8 BOM"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137015#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN MS Excel 2003 XML fails when having double UTF-8 BOM"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137015">bug 137015</a>
from <span class="vcard"><a class="email" href="mailto:momonasmon@gmail.com" title="Maxim Monastirsky <momonasmon@gmail.com>"> <span class="fn">Maxim Monastirsky</span></a>
</span></b>
<pre>(In reply to plasticassius from <a href="show_bug.cgi?id=137015#c0">comment #0</a>)
<span class="quote">> An attempt to open an MS Excel 2003 XML format file that includes the xml
> version tag <?xml version="1.0"?> on the first line fails, and an attempt to
> import the file as text is made.</span >
The problem isn't with the version tag, but with the file having the UTF-8 BOM
twice. It just happens that when you attempt to edit the file to remove the
version tag, the redundant BOM is also removed.
<span class="quote">> $soffice --headless --infilter="MS Excel 2003 XML" --convert-to ods file.xls</span >
Here you're attempting to use the obsolete "MS Excel 2003 XML" filter, instead
of the new and much improved "MS Excel 2003 XML Orcus" which is the one used in
the UI by default. In most cases there is no need to explicitly specify the
input filter, as LO can figure out the filter itself. In addition, there is no
need to specify --headless when you already have --convert-to.</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>