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

Formula dependency

Thread ID:

Created:

Updated:

Platform:

Replies:

7709 Oct 7,2003 07:36 AM Oct 7,2003 11:20 AM Windows Forms 1
loading
Tags: GridControl
Andrey Samsonov
Asked On October 7, 2003 07:36 AM

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

CONFIRMATION

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.

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.

;