We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Formula dependency

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?

1 Reply

AD Administrator Syncfusion Team October 7, 2003 03:20 PM UTC

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. Thanks, Stefan

Live Chat Icon For mobile
Up arrow icon