Hi Rolf. Formulas are evaluated by Excel at the next usage of the file.
Regards, Karl-Heinz. -----Urspr�ngliche Nachricht----- Von: ROLLIN F GssiItsRet [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 4. Mai 2005 09:36 An: [email protected] Betreff: How to get the result of a formula ? Hello I'm using a complex Excel WorkBook to validate the result of a java program. In fact, I set values in different HSSFCell of HSSFWorkbook created from a model, and I try to read the result in a formula cell (wich already exists in the model). When I use the getNumericCellValue() method, I get a NaN value... Is there a task to do for updating the formula in order to get its result ? Thanks ROLF ======================================================= Ce message et toutes les pieces jointes (ci-apres le "message") sont confidentiels et etablis a l'intention exclusive de ses destinataires. Toute utilisation ou diffusion non autorisee est interdite. Tout message electronique est susceptible d'alteration. La SOCIETE GENERALE et ses filiales declinent toute responsabilite au titre de ce message s'il a ete altere, deforme ou falsifie. ======================================================= This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorized use or dissemination is prohibited. E-mails are susceptible to alteration. Neither SOCIETE GENERALE nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified. ======================================================= --------------------------------------------------------------------- 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/
