Bug 21447

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

3.0

Comment 3 Avik Sengupta 2003-10-30 18:54:35 UTC

This is in CVS as of 20Aug. Will go into 2.0RC1