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]