POI only puts the formula into the cell. It does not calculate the result. You have to open the POI-generated spreadsheet in Excel to see the result.
-----Original Message----- From: Tandon, Rishi (Institutional Securities Management) [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 6:42 AM To: POI Users List Subject: Evaluating formulas Hi All, I have a cell that is dependent on today's date and goes behind specific offset, as specified in C13, of days. I am able to make the change to C13, the offset, but when I try to read the calculated date cell, I am unable to get the correct date. I am using POI 2.5 in my project. Is there any way to force automatic evaluation of formulas on the cells that are dependent on other cells? Regards, Rishi -------------------------------------------------------- NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. --------------------------------------------------------------------- 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]
