Bug 21447 - [RFE]String Formula Cells
Summary: [RFE]String Formula Cells
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.0-dev
Hardware: Other Linux
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2003-07-09 20:49 UTC by Ayal Leibowitz
Modified: 2004-11-16 19:05 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
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