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/07/09 22:49:40 UTC

DO NOT REPLY [Bug 21447] New: - String Formula Cells

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=21447>.
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=21447

String Formula Cells

           Summary: String Formula Cells
           Product: POI
           Version: 2.0-dev
          Platform: Other
        OS/Version: Linux
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: ayal@modelity.com


I have formula cells, which return strings. Trying to read their values using 
getStringCellValue() returns null (getNumericCellValue() returns NaN, which is 
the expected value).
An example of a cell formula is: =IF(A1=0,"Sell","Buy")

Any help would be appreciated,
Ayal Leibowitz.