https://bugs.freedesktop.org/show_bug.cgi?id=86277
Bug ID: 86277
Summary: Filesave: Libreoffice vs Excel 2010 worksheet saved as
.xlsx not opened correctly in (python) pandas/xlrd:
hidden column information
Product: LibreOffice
Version: 4.2.6.3 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 109452
--> https://bugs.freedesktop.org/attachment.cgi?id=109452&action=edit
Minimal example of a working file, and one non-working file.
An .xlsx document is created in MS Excel 2010. When opened in Libreoffice, and
saved again as .xlsx document (MS Excel 2007/'10/'13 xml format), it seems
perfectly readable and writeable in both Excel and LibreOffice.
However, opening of said .xlsx file fails using the scientific python package,
pandas (which uses the python "xlrd" module to read/write .xlsx files).
WORK AROUND: The non-working .xlsx file can be made working by selecting all
not used columns (from C to AMZ or whatever is the last column name), then
rightclick and "delete columns...", and followed by saving again as .xlsx file.
I have attached a zip file with two documents: "works_no.xlsx" does not open in
Python pandas, whereas "works_yes.xlsx" does work. File "works_no.xlsx" can be
made to open correctly by applying the work-around.
The test to perform is, using Python (I use the IPython notebook and
interactive shell) and the pandas package:
import pandas as pd
myFile = pd.ExcelFile("works_no.xlsx")
myFile.sheet_names
The result of this operation is an AssertionError.
When the "works_yes.xlsx" file is used, the correct output (that is, the sheet
names for the file) are correctly displayed.
It seems that LibreOffice does write some additional data into some of the
empty columns, but I was unable to find any hidden character.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
