https://bugs.freedesktop.org/show_bug.cgi?id=80859
Priority: medium
Bug ID: 80859
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: LO Calc: error opening MS Excel 2003 XML document
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: bob...@ukr.net
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.5.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 102204
--> https://bugs.freedesktop.org/attachment.cgi?id=102204&action=edit
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 &
^
...
---
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
