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.

Reply via email to