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 2003/04/03 11:40:37 UTC

DO NOT REPLY [Bug 18646] New: - Reading formula cells causes [WARNING] Unknown Ptg 2 (2) at cell (3,0)

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.