We have a large grid and use formulas, but such formulas as SUM or AVG work too slowly for a large range of cells. Weak spot is function GridFormulaEngine.GetValueFromArg().
We have rewritten SUM, AVG and MAX formulas. In our functions we don't use GridFormulaEngine.GetValueFromArg() function and retrieve data immediately from our data source. Now these formulas work much faster, but a new difficulty has arisen: when user changes cell value, the depended on this cell formulas aren't recalculated, even after calling GridFormulaEngine.RefreshRange() method.
For example a cell has formula "=SUM(A1:A10)". After changing A5 cell this formula should be recalculated, but it isn't.
How we can impel to recalculate our formulas?
ADAdministrator Syncfusion Team October 7, 2003 10:20 AM
Can I ask you to post that question again in 2 weeks when Clay is back from vacation?
He is really the expert for the Formula Engine and should be able to help you out much better then.
Sorry about the inconvience.