Which version of excel is supported by POI? I write to an excel(which has formulas) file using POI2.0. But looks like the writing to excel is fine. When i try to get the value, it does not give me the latest value that is written thru POI, instead it gives me the previously stored value. When I try to open the excel file using excel 2000, 9.1.3.021, and try to close it without doing any changes, I get an alert message saying "Do you want to save the changes made to xxx.xls? Microsoft Excel recalculates formulas when opening files last saved by an earlier version of Excel"
If I save, only then i get the latest value otherwise i get the previously stored value. How do i get the latest value of a cell which contains formula? Thanks Suma --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
