Here's what I did: In POI:
1) open the spreadsheet 2) change some (non-formula) data cell values 3) re-calc everything 4) save the spreadsheet (to a new file) In Excel: 1) open the spreadsheet (the calculated values are correct) 2) manually change a data cell The calculated cells that should change, don't. If I change my code to set the formula after the re-calc, it works as expected. It will take me a little while to reproduce it using a simple spreadsheet, but I'll try to do so. -J -----Original Message----- From: Nick Burch [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2008 11:18 AM To: POI Users List Subject: RE: HSSF formula cells not calculating On Wed, 19 Mar 2008, J Keller wrote: > Although the values were correctly calculated, the formula cells would > not recalculate when I changed the normal data cells. Adding the > setCellFormula fixed it. Where did you change the normal data cells though? In excel, or in poi? If you change them in poi, you then need to do another re-calculation afterwards Nick --------------------------------------------------------------------- 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]
