~~Nick Wrote: IIRC, calling getNumericCellValue() on a formula cell ought to return the result of the formula, but only if the formula has been evaluated. If nothing has evaluated the formula, the answer will be blank.
Opening the file in excel and saving it again ought to sort it, as would using the formula parser code in the scratchpad to calculate it yourself I didn't actually get what you want to say. Do you mean that I will have to evaluate the formula result myself in the code? Isn't there's a way by which I can get the result of the formula? Thanks & Regards Ved Gunjan. Incubation Center, C -201/ Unit No: 5, Pune IT Park, Aundh Rd, Pune, India. Meet Me Details: Tel: 91.20.30223.100 | Fax: 91.20.30223.100 | Cell: 9890015916 www.yagnaiq.com ________________________________ "Lack of will power has caused more failure than lack of intelligence or ability" -----Original Message----- From: Nick Burch [mailto:[EMAIL PROTECTED] Sent: Monday, October 08, 2007 5:26 PM To: POI Users List Subject: Re: How to read the Content of the cell whose type is : CELL_TYPE_FORMULA On Sun, 7 Oct 2007, vedgunjan wrote: > The Problem is, the cell which are of type HSSFCell.CELL_TYPE_FORMULA, > on reading the value of the cell,using cell.getCellFormula(), am getting > the formula as string, but actually I want the value which is present in > that cell. IIRC, calling getNumericCellValue() on a formula cell ought to return the result of the formula, but only if the formula has been evaluated. If nothing has evaluated the formula, the answer will be blank. Opening the file in excel and saving it again ought to sort it, as would using the formula parser code in the scratchpad to calculate it yourself Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
