https://issues.apache.org/bugzilla/show_bug.cgi?id=47606
Summary: XSSFCell.parseCellNum is not working for more than 702
(ZZ) rows
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
When reading an Excel 2007 sheet with rows with more than 702 columns the
method XSSFRow.getLastCellNum() reports 702 instead of the correct number.
The problem seems to be in the class XSSFCell. The method parseCellNum(String)
does not work for more then two characters:
protected static short parseCellNum(String r)
{
r = r.split("\\d+")[0];
if(r.length() == 1)
return (short)(r.charAt(0) - 65);
else
return (short)((r.charAt(1) - 65) + 26 * (r.charAt(0) - 64));
}
Regards
Rolf
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
