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 18646] New: - Reading formula cells causes [WARNING] Unknown Ptg 2 (2) at cell (3,0)
Date Thu, 03 Apr 2003 09:40:37 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=18646>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=18646

Reading formula cells causes [WARNING] Unknown Ptg 2 (2) at cell (3,0)

           Summary: Reading formula cells causes [WARNING] Unknown Ptg 2 (2)
                    at cell (3,0)
           Product: POI
           Version: unspecified
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: gerhard.kunisch@gmx.net


Hello,

just want to extract data from an excel spreadsheet using POI version 1.10.0-dev
When parsing a formula cell containing =(if(isempty(B4);1;0)) the warning:
[WARNING] Unknown Ptg 2 (2) at cell (3,0)
is send to stdout.
Applying the line
System.out.println("Cell("+columnNumber+"/"+rowNumber+") contains formula: " + 
cell.getCellFormula() + " string representation " + cell.getStringCellValue());

Cell(0/3) contains formula: #NAME string representation null.

I use the German version of Excel 95.

Mime
View raw message