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.
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.
3.0
This is in CVS as of 20Aug. Will go into 2.0RC1