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.

Programmatically refreshing the values of a formula cell

Thread ID:





3425 Mar 18,2003 06:40 AM Mar 18,2003 08:14 AM Windows Forms 1
Tags: GridControl
Mark Prothro
Asked On March 18, 2003 06:40 AM

How can I force a formula cell to apply a formula to cells in the grid programmatically? The only way I have been able to get a formula cell to refresh is when I modify the contents of one of the cells referenced in the formula. Form_Load Me.GridControl1(1, 1).CellType = "FormulaCell" Me.GridControl1(1, 1).Text = "=sum(b1:c1)" Me.GridControl1(1, 2).Text = 10 Me.GridControl1(1, 3).Text = 10 'Me.GridControl1(1, 1).CellType will be 20 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Me.GridControl1(1, 3).Text = 100 End Sub 'Me.GridControl1(1, 1).CellType will STILL be 20

Administrator [Syncfusion]
Replied On March 18, 2003 08:14 AM

This is a bug. Until we get it corrected, when you programatically set a value, you can force a refresh of dependent cells by calling GridFormulaEngine.Refresh or GridFormulaCellModel.Refresh passing in the cell.


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.