https://bugs.freedesktop.org/show_bug.cgi?id=86277
Robinson Tryon (qubit) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTOURBUG --- Comment #6 from Robinson Tryon (qubit) <[email protected]> --- TESTING with LO 4.4.0.0.beta1 + Ubuntu 14.04 (and Pandas 0.13.1, for both Python 2 and Python 3) (In reply to douwe van der veen from comment #0) > 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). Given that the file continues to work in Excel and LibreOffice, could this be a bug in Pandas? REPRO steps: 1) $ sudo apt-get install python-pandas python3-pandas python3-xlrd 2) Test against pandas $ python # or python3 >>> import pandas as pd >>> myFile = pd.ExcelFile("works_no.xlsx") >>> myFile.sheet_names Result: PARTIAL CONFIRMATION -- This test actually throws an Assertion Error BEFORE we even query for sheet_names. --- File "/usr/lib/python2.7/dist-packages/xlrd/xlsx.py", line 89, in cell_name_to_rowx_colx assert 0 <= colx < X12_MAX_COLS AssertionError --- Same error with Python3: --- File "/usr/lib/python3/dist-packages/xlrd/xlsx.py", line 89, in cell_name_to_rowx_colx assert 0 <= colx < X12_MAX_COLS AssertionError --- > 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. Yes, CONFIRMED. I tested the two XLSX files using Office-o-tron, and both passed validation: https://wiki.documentfoundation.org/ODF#Office-o-tron Given that the files validate, it looks like this a bug in Pandas. Given that it's the one throwing the error, please talk to their devs first, and see if they have an idea of how the file is malformed. If they think it's a bug in LibreOffice, please provide a comment with reasoning and change the status back to UNCONFIRMED. Status -> RESOLVED NOTOURBUG -- 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
