Is there any way I can force excel to recalculate the sheet when it is opened ?
We're using 1.5-Final, and I'm opening an existing spreadsheet as a template, filling in some cells with values the user entered into a web-app. Now the template spreadsheet has some formulae based on the values I updated but the formulae aren't getting recalculated, at least with out pressing Ctrl-Alt-F9 in excel ;) I was hoping there would be a HSSFSheet.setCalculateFlag(boolean) method or similar available, or is this tied into incomplete the formula implementation in the 1.5 release ? Apart from this one glitch we are delighted with the results we're seeing with POI. Cheers, Nigel. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
