|Summary:||[RFE]String Formula Cells|
|Product:||POI||Reporter:||Ayal Leibowitz <ayal>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
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