[Libreoffice-bugs] [Bug 86277] Filesave: Libreoffice vs Excel 2010 worksheet saved as .xlsx not opened correctly in (python) pandas/xlrd: hidden column information

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=86277

--- Comment #8 from douwe van der veen  ---
For reference:
For information only:

the python-excel package people appears to have fixed this issue, see
https://github.com/python-excel/xlrd/issues/56

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 86277] Filesave: Libreoffice vs Excel 2010 worksheet saved as .xlsx not opened correctly in (python) pandas/xlrd: hidden column information

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=86277

--- Comment #7 from douwe van der veen douwevdv...@yahoo.com ---
Thanks for testing both .xlsx files.

I have reported this issue to the 'python-excel' xlrd package, which is the
Python module that is used under the hood by pandas package in which I came
across this error.

It appears that this bug/issue has been reported there before, so I have added
a reference to the earlier reported issue in the xlrd bug tracker: 

https://github.com/python-excel/xlrd/issues/56


Best regards,
Douwe

-- 
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

[Libreoffice-bugs] [Bug 86277] Filesave: Libreoffice vs Excel 2010 worksheet saved as .xlsx not opened correctly in (python) pandas/xlrd: hidden column information

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=86277

Robinson Tryon (qubit) qu...@runcibility.com changed:

   What|Removed |Added

 CC||qu...@runcibility.com

--- Comment #4 from Robinson Tryon (qubit) qu...@runcibility.com ---
Created attachment 109820
  -- https://bugs.freedesktop.org/attachment.cgi?id=109820action=edit
Works_No

Add test file individually

-- 
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

[Libreoffice-bugs] [Bug 86277] Filesave: Libreoffice vs Excel 2010 worksheet saved as .xlsx not opened correctly in (python) pandas/xlrd: hidden column information

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=86277

--- Comment #5 from Robinson Tryon (qubit) qu...@runcibility.com ---
Created attachment 109821
  -- https://bugs.freedesktop.org/attachment.cgi?id=109821action=edit
Works_Yes

Add attachment individually

-- 
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

[Libreoffice-bugs] [Bug 86277] Filesave: Libreoffice vs Excel 2010 worksheet saved as .xlsx not opened correctly in (python) pandas/xlrd: hidden column information

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=86277

Robinson Tryon (qubit) qu...@runcibility.com changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |NOTOURBUG

--- Comment #6 from Robinson Tryon (qubit) qu...@runcibility.com ---
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
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 86277] Filesave: Libreoffice vs Excel 2010 worksheet saved as .xlsx not opened correctly in (python) pandas/xlrd: hidden column information

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=86277

Julien Nabet serval2...@yahoo.fr changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

--- Comment #3 from Julien Nabet serval2...@yahoo.fr ---
I put it as UNCONFIRMED since I don't have more questions.

-- 
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

[Libreoffice-bugs] [Bug 86277] Filesave: Libreoffice vs Excel 2010 worksheet saved as .xlsx not opened correctly in (python) pandas/xlrd: hidden column information

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=86277

Julien Nabet serval2...@yahoo.fr changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||serval2...@yahoo.fr
 Ever confirmed|0   |1

--- Comment #1 from Julien Nabet serval2...@yahoo.fr ---
For the test, could you give a try to last stable LO version 4.3.3?

-- 
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

[Libreoffice-bugs] [Bug 86277] Filesave: Libreoffice vs Excel 2010 worksheet saved as .xlsx not opened correctly in (python) pandas/xlrd: hidden column information

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=86277

Julien Nabet serval2...@yahoo.fr changed:

   What|Removed |Added

 Attachment #109452|text/plain  |application/zip
  mime type||

-- 
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

[Libreoffice-bugs] [Bug 86277] Filesave: Libreoffice vs Excel 2010 worksheet saved as .xlsx not opened correctly in (python) pandas/xlrd: hidden column information

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=86277

--- Comment #2 from douwe van der veen douwevdv...@yahoo.com ---
Tested on Ubuntu 14.10 (fully updated 2014-11-14). 
Libreoffice: Version: 4.3.3.2,  Build ID: 430m0(Build:2)

I have opened both attached documents in LO 4.3.3.2, saved as .xlsx, and
closed. The works_no file cannot be loaded from python/pandas, whereas
works_yes will do so. The workaround works as expected.

Thus: similar behavior with LO 4.3.3.2 on my system.

Ad1 -- When I open the works_no.xlsx container using an archive manager, in
the file /xl/worksheets/sheet1.xml there is a large string of information on
extra columns. No clue if this is significant, but this line is removed after
applyign workaround and saving file again. The string looks like: c r=C1
s=0/c r=D1 s=0/c r=E1 s=0/c r=F1 s=0/c r=G1 s=0/c
r=H1 s=0/ etc etc.

Ad2 -- I am able to convert the works_no.xlsx file, but I haven't been able
to reproduce the  works_no.xlsx file from scratch. It appeared somewhere in
my workflow from Excel to LibreOffice. Not sure how much time to put into this
bug, but I'm reporting as it might point to differences between LO/Excel.

Thanks!

-- 
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