| Summary: | FILEOPEN: Importing XML Excel spreadsheet. It gives an Input/Output error | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Jorge Blumenfeld <leruse+bugzilla> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | momonasmon |
| Priority: | medium | ||
| Version: | 3.5.7.2 release | ||
| Hardware: | Other | ||
| OS: | Windows (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | One XML Spreadsheet that opens in excel (or in previous LibreOffice Versions) without problem | ||
Hi, The problem is that your XML is missing encoding declaration (the first line should look like <?xml version="1.0" encoding="ISO-8859-1"?>). After adding that line, the file opens without any problem. The reason for such behavior is that LibreOffice uses libxml2 library, which assumes UTF-8 or UTF-16 when there isn't an encoding declaration, see http://www.xmlsoft.org/encoding.html#implemente. So I'm afraid it's a WONTFIX, but I can't speak for the developers, so I'll leave this bug open for now. BTW Are you sure that it opens in 4.1.1.2, as it won't open your file for me. Also tried with 4.0.5, 3.6.7, 3.5.7 with exactly the same results. Tested on Windows 7 (32-bit). That file has a mix of UTF-8 and ANSI encoded characters. It's invalid. |
Created attachment 87330 [details] One XML Spreadsheet that opens in excel (or in previous LibreOffice Versions) without problem Problem description: Steps to reproduce: 1. Try to open an XML spreadsheet. No matter wich file extension it has (xml, xlsm, xlm, etc.) Current behavior: msgbox "Error general de Entrada/salida" Expected behavior: file open sucessfully Operating System: Windows 8 Version: 4.1.2.3 rc Last worked in: 4.1.1.2 release