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

Formulas

Thread ID:

Created:

Updated:

Platform:

Replies:

2335 Jan 8,2003 04:47 PM UTC Jan 8,2003 09:03 PM UTC WinForms 1
loading
Tags: GridControl
Scott Todd
Asked On January 8, 2003 04:47 PM UTC

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

Administrator [Syncfusion]
Replied On 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

CONFIRMATION

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