I am having a problem with a formula calculating after I insert a column (using InsertRange). Even if I reset the formula, it still won''t work.
The attached sample shows an example. When the form first loads, the formula works fine. If the button is clicked (which adds a column using InsertRange), the value of the formula cell doesn''t change when any of its dependent cells is changed.
Am I doing something wrong, or is this a DirectTrac issue?
FYI: I am running 1.6.1.
ADAdministrator Syncfusion Team April 6, 2004 05:02 PM
In 1.6.1, resetting the formulatag does seem to avoid the problem. In 2030, you can clear a couple of hashtables and recalculate things without having to visit each cell trying to reset the formulatag.
Here is code that seemed to avoid teh problem in 1610 for me.