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

How to show the formula in a cell on activating the cell in WinForms GridControl?

Platform: WinForms |
Control: GridControl |
Published Date: May 13, 2016 |
Last Revised Date: June 20, 2021
Tags: celltype, formula

Show the formula in a cell

By default, the formula will be shown in a cell even if it is in edit mode. In order to show the formula in a cell when cell is activated, the ForceEditWhenActivated property can be set as False.

C#

this.gridControl1.ActivateCurrentCellBehavior = GridCellActivateAction.DblClickOnCell;
GridFormulaCellRenderer.ForceEditWhenActivated = false;

 

VB

Me.gridControl1.ActivateCurrentCellBehavior = GridCellActivateAction.DblClickOnCell
GridFormulaCellRenderer.ForceEditWhenActivated = False

 

Screen shot

shows the formula in a cell

Samples:

C#: ActivateFormulaCell_CS

VB: ActivateFormulaCell_VB

Reference link: https://help.syncfusion.com/windowsforms/grid-control/formula-support

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

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