[Libreoffice-bugs] [Bug 137015] FILEOPEN MS Excel 2003 XML fails when having double UTF-8 BOM

[bugzilla-daemon at bugs.documentfoundation.org]

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

Maxim Monastirsky <momonasmon at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|FILEOPEN MS Excel 2003 XML  |FILEOPEN MS Excel 2003 XML
                   |fails when header includes  |fails when having double
                   |<?xml version="1.0"?>       |UTF-8 BOM

--- Comment #1 from Maxim Monastirsky <momonasmon at gmail.com> ---
(In reply to plasticassius from comment #0)
> 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.
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.

> $soffice --headless --infilter="MS Excel 2003 XML" --convert-to ods file.xls
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.

-- 
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/20200925/6c4ac41f/attachment.htm>