Bug 21447

Summary: [RFE]String Formula Cells
Product: POI Reporter: Ayal Leibowitz <ayal>
Component: HSSFAssignee: POI Developers List <dev>
Severity: normal    
Priority: P3    
Version: 3.0-dev   
Target Milestone: ---   
Hardware: Other   
OS: Linux   

Description Ayal Leibowitz 2003-07-09 20:49:39 UTC
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.
Comment 1 Avik Sengupta 2003-07-10 04:37:44 UTC
Yep, not yet implemented, someone needs to have a go at it. Unlike the number
value, the String value is not stored in the formula record, but in a string
record following the formula record. 

In the POI object model, the string record is available as part of the
FormulaRecordAggregate object, but how to get access to that object from the
FormulaRecord needs to be figured. It'll probably be just a few lines of code,
but needs to be thought thru. 
Comment 2 Andy Oliver 2003-07-24 17:08:45 UTC
Comment 3 Avik Sengupta 2003-10-30 18:54:35 UTC
This is in CVS as of 20Aug. Will go into 2.0RC1