On Tue, 18 Mar 2008, J Keller wrote:
Using poi-3.0-rc4, I'm reading an Excel spreadsheet (which works fine); changing some values (which works fine), and saving it out as a new version (which also works fine).

But, when I open the spreadsheet, all of my formula cells are not calculated (nor can I tell the spreadsheet to recalc using F9 for example).

That's expected. You either need to force excel to re-calculate on load, or do the recalculation yourself:
        http://poi.apache.org/hssf/eval.html
By default, excel will just used the cached formula values

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to