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/