How to get String result from a cell with a formula behind

2007-04-04 Thread ChrisHauser 

Trying to retrieve the result of a cell where I have the following formula:
=SUBTOTAL(9,P4:P27)

I have tried the following methods:
HSSFCell.getNumericCellValue()  
HSSFCell.getRichStringCellValue().getString() -- returns empty string 

All these results do not match to what I have in my MSExcel spread sheet.

Any help is greatly appreciated.

Chris
-- 
View this message in context: 
http://www.nabble.com/How-to-get-String-result-from-a-cell-with-a-formula-behind-tf3526397.html#a9839111
Sent from the POI - User mailing list archive at Nabble.com.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

RE: How to get String result from a cell with a formula behind

2007-04-04 Thread Karr, David 
I'm new at this also, but you should probably use the
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator class from the
scratchpad jar. 

 -Original Message-
 From: ChrisHauser [mailto:[EMAIL PROTECTED] 
 Sent: Wednesday, April 04, 2007 8:49 AM
 To: poi-user@jakarta.apache.org
 Subject: How to get String result from a cell with a formula behind
 
 
 Trying to retrieve the result of a cell where I have the 
 following formula:
 =SUBTOTAL(9,P4:P27)
 
 I have tried the following methods:
 HSSFCell.getNumericCellValue()
 HSSFCell.getRichStringCellValue().getString() -- returns 
 empty string 
 
 All these results do not match to what I have in my MSExcel 
 spread sheet.
 
 Any help is greatly appreciated.
 
 Chris
 --
 View this message in context: 
 http://www.nabble.com/How-to-get-String-result-from-a-cell-wit
h-a-formula-behind-tf3526392.html#a9839101
 Sent from the POI - User mailing list archive at Nabble.com.
 
 
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 Mailing List: http://jakarta.apache.org/site/mail2.html#poi
 The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
 
 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/