On Wed, 19 Mar 2008, J Keller wrote:
According to the docs, that is the method I want. But it didn't work
correctly for me. When I used the "recalc spreadsheet" code from the
docs page, it did put calculated values into the cells, but they would
not update when I changed any of the data in the other cells referenced
by the formula.
Hmm, not sure if what you're seeing is a bug or not. Are you doing:
* update all cell values
* recalculate all formulas
* save
Or are you trying to do it in a different order? If you're doing it in
that order, and things aren't being correctly re-calculated, please do
open a new bug and upload a little unit test that shows off the issue.
Once I added the call to setCellFormula, it worked fine. This looks
like a bug.
That shouldn't be needed, assuming you're doing everything in the right
order
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]