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.
Up arrow icon