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.