| Summary: | FILEOPEN: error opening MS Excel 2003 XML document | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Bob Bib <bobbib> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | ign_christian, momonasmon |
| Priority: | medium | ||
| Version: | 4.2.5.2 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | zipped document #1 | ||
Test System: Kubuntu 4.13.2 LibreOffice 4.2.0.2 Was able to confirm that the attached (unzipped) file will not open into LibreOffice cal. I get text file import with a file-click open or from within calc. Odd problem.. @Maxim, would you mind have a quick look here? |
Created attachment 102204 [details] zipped document #1 Software environment: libreoffice/1:4.2.5-1 @ Debian/amd64 --- After extracting the document from the attached ZIP archive: a) if you just try to open it in LO Calc, it just opens a "Text Import" dialog, which is not helpful; b) if you try to open it via the file open dialog, explicitly selecting the "Microsoft Excel 2003 XML" file type, it tries to open the document, but fails with "General Error. General input/output error." However, there are some helpful things in the console output (see below), so after making the followings steps it finally opens up the document: 1) remove the newline at the beginning of the file; 2) replace the " "'s with ordinary spaces; 3) replace single ampersands with "&"'s. --- Entity: line 2: parser error : XML declaration allowed only at the start of the document <?xml version="1.0"?> ^ Entity: line 139: parser error : Entity 'nbsp' not defined <Cell ss:StyleID="sC1"><Data ss:Type="String"> 01813</Data></Cell> ^ ... Entity: line 6036: parser error : xmlParseEntityRef: no name ss:StyleID="sP2"><Data ss:Type="String">Пульт Philips RC242252901652 (HDD & ^ ... ---