Hi, I am using 'org.apache.poi.hssf.usermodel' package to read an excel file containing formulas.While reading the file,I change the values of some Numeric cells(on which certain formulas are based in the original excel file) and write all the values in to a new excel file,Using HSSFWorkbook.write() function. But when I print the cell values by reading the newly created excel file, I get the changed values only for the numeric cells that I changed earlier.Formula cells retain their old values,but when I open that excel file it shows the formula cell values are changed correctly. Has it something to do with 'how and when' the formulas are calculated in the MS Excel.(when I close the newly created excel file it opens a dialog box with message "Do you want to save the changes you made in 'tempFile.xls'. Microsoft Excel recalculates the formulas when opening files last saved by an earlier version of excel" .If I click 'yes' button and again try to read that excel only then it gives me correct cell values.)
Please throw some light in this issue,so that I can get through. Thanks and regards. Kuldeep. --------------------------------------------------------------------- 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/
