poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 47606] New: XSSFCell.parseCellNum is not working for more than 702 (ZZ) rows
Date Thu, 30 Jul 2009 08:28:53 GMT
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


Mime
View raw message