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 not refreshing

Thread ID:





18647 Sep 6,2004 10:01 AM Sep 7,2004 11:35 AM Windows Forms 8
Tags: GridControl
Asked On September 6, 2004 10:01 AM

I have a gridControl with formula cells but they are not recalculating when I change values on the cells that I want and are presente in the formula. Can you help me?

Administrator [Syncfusion]
Replied On September 6, 2004 11:18 AM

What version are you using? Do you see the problem in If you are using, you might try setting engine.UsesVirtualDataSource = true to see if that makes things update?

Replied On September 7, 2004 08:26 AM

I''m using the latest build that I downloaded from your website

Administrator [Syncfusion]
Replied On September 7, 2004 09:21 AM

At the end of your FormLoad (after the grid has been initialized, you might add this code to see if it makes a difference. GridFormulaEngine engine = ((GridFormulaCellModel)this.gridCalculations.CellModels["FormulaCell"]).Engine; engine.RecalculateRange(GridRangeInfo.Table()); If not, can you post a sample project that shows the problem, or can you tell us how to see the problem in one of the samples that we ship?

Replied On September 7, 2004 10:30 AM

I guess I found what the problem is... I currently have two grids (let''s call them grid1 and grid2). When I click and element of grid1 it automatically passes the value to grid2. I have the formula in grid2 and it is not refreshing when the value is passed from grid1. All other formulas are working so it must be from this. I guess the value passed from one grid to another is not being validated in grid2. I''m passing it like this from one grid to another: Me.grid2.Item(0, 3).CellValue = Me.grid1.SelectedItems(0).Text

Administrator [Syncfusion]
Replied On September 7, 2004 10:43 AM

I didn''t discovered what is wrong. Can you help me?

Administrator [Syncfusion]
Replied On September 7, 2004 11:05 AM

After setting Me.grid2.Item(0, 3).CellValue, try calling engine.RecalculateRange(GridRangeInfo.Cell(0, 3)) to see if that triggers the refresh. Here engine is a reference to the GridFormulaEngine object. Another thing you can try is code like this after setting Me.grid2.Item(0, 3).CellValue. Me.grid2.Item(0, 3).FormulaTag = Nothing Dim s as string = Me.grid2.Item(0, 3).FormattedText This tries to force the

Administrator [Syncfusion]
Replied On September 7, 2004 11:18 AM

I did a recalculateRange and it worked. Nevertheless it is not very fast. As a satisfied user of your grid it''s my duty to recommend syncfusion to review this issue as it is very important. Other grids do this with no trouble. Nevertheless this grid is very good ;)

Administrator [Syncfusion]
Replied On September 7, 2004 11:35 AM

Can you post a sample so we can see the problem and try to do something about it?


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.