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

Formulas

I'm needing to use formulas in a grid, but the user should not be able to see the formula when the user clicks on the cell. How can I do this. Scott

1 Reply

AD Administrator Syncfusion Team January 8, 2003 09:03 PM UTC

You can handle the CurrentCellStartEditing event and cancel it if the current cell is a formula cell.
Private Sub GridControl1_CurrentCellStartEditing(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles GridControl1.CurrentCellStartEditing
	Dim cc As GridCurrentCell = Me.GridControl1.CurrentCell
	If cc.Renderer.GetType() Is GetType(GridFormulaCellRenderer) Then
		e.Cancel = True
	End If
End Sub

Loader.
Live Chat Icon For mobile
Up arrow icon