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: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] 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. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
