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
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Formula dependency

Thread ID:





7709 Oct 7,2003 11:36 AM UTC Oct 7,2003 03:20 PM UTC WinForms 1
Tags: GridControl
Andrey Samsonov
Asked On October 7, 2003 11:36 AM UTC

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?

Administrator [Syncfusion]
Replied On 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


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon