You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2009/07/30 10:28:53 UTC
DO NOT REPLY [Bug 47606] New: XSSFCell.parseCellNum is not working
for more than 702 (ZZ) rows
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: dev@poi.apache.org
ReportedBy: tyzuk@web.de
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 47606] XSSFCell.parseCellNum is not working for
more than 702 (ZZ) colums
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47606
Rolf Tyzuk <ty...@web.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|XSSFCell.parseCellNum is |XSSFCell.parseCellNum is
|not working for more than |not working for more than
|702 (ZZ) rows |702 (ZZ) colums
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 47606] XSSFCell.parseCellNum is not working for
more than 702 (ZZ) colums
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47606
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #1 from Yegor Kozlov <ye...@dinom.ru> 2009-08-05 10:02:29 PDT ---
Fixed in r801305
Regards,
Yegor
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org