If its indeed a formula cell, the cell type sould be FORMULA ... getCellFormula() will get you a string representing the formula, while getNumricCellValue() will get you the result of the formula if its a number. Remember, the result will have to be calculated in excel and available in the saved file. POI does not calculate formulas by itself.
-------Original Message------- > From: Koketso Mabusela <[EMAIL PROTECTED]> > Subject: Fomula cell > Sent: 29 Oct 2003 11:53:12 > > Hi > > I am trying to get data from a formula cell. The cell type comes up as > Numeric but it comes back as Zero. It does not retrieve the > Calculated values. How can I retrieve the calculated values? > > Koketso Mabusela > Liberty Personal Benefits > > > > > ******************************************************************* > > The e-mail and attachments are confidential and intended only for selected recipients. If you have received it in error, you may not in any way disclose or rely on the contents. You may not keep, copy or distribute the e-mail. Should you receive it, immediately notify the sender of the error and delete the e-mail.Also note that this form of communication is not secure, it can be intercepted, and may not necessarily be free of errors and viruses in spite of reasonable efforts to secure this medium. > > ******************************************************************* -------Original Message-------
