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

Programmatically refreshing the values of a formula cell

Thread ID:





3425 Mar 18,2003 11:40 AM UTC Mar 18,2003 01:14 PM UTC WinForms 1
Tags: GridControl
Mark Prothro
Asked On March 18, 2003 11:40 AM UTC

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 01:14 PM UTC

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.

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