https://bugs.documentfoundation.org/show_bug.cgi?id=150023
Bug ID: 150023
Summary: Double BOM (invalid XML) prevents importing some Excel
2003 XML (Excel reads them)
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Created attachment 181293
--> https://bugs.documentfoundation.org/attachment.cgi?id=181293&action=edit
A sample Excel 2003 XML with double BOM
The attachment is from
https://www.blackrock.com/il/intermediaries/en/products/264107/ishares-spi-ch-fund/1554770013246.ajax?fileType=xls&fileName=iShares-Core-SPI-ETF-CH_fund&dataType=fund.
A user reported on IRC that it can't be opened in Calc, while Excel opens it
fine.
The UTF-8 XML file has a double BOM - and that makes it actually invalid, since
after stripping the first BOM, the rest XML does not begin with XML
declaration, but with a zero-width character.
See also bug 68742, which was fixed with an improvement in orcus.
--
You are receiving this mail because:
You are the assignee for the bug.