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?
