[Bug 61034] Call to XSSFReader.getSheetsData() returns duplicate sheets

[bu...@apache.org]

https://bz.apache.org/bugzilla/show_bug.cgi?id=61034

--- Comment #1 from Sebastian Wikalinski <se...@nokia.com> ---
Created attachment 34964
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=34964&action=edit
Proposed fix for XSSFReader.XMLSheetRefReader

Hi,

We've run into the same issue with the new version of the library. The problem
seems to be caused only by those xlsx files which have a specific order of the
attributes inside the <sheet> tag of workbook.xml 

Example (which causes the problems):
<sheet name="Sheet6" r:id="rId6" sheetId="4"/>

While this one works correctly:
<sheet name="Sheet6" sheetId="4" r:id="rId6"/>

I've traced the root cause to a possible coding error in XMLSheetRefReader, for
which I'm now providing a patch. I haven't tested it very thoroughly, but it
seems to fix the problem.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org