GridControl - Excel like range selection in formulas

Question

Good day,I would like to be able to begin typing in a formula and then click on another cell, or range of cells, to apply to an argument in a formula, like you can do in excel. This behavior does not seem to be present by default. Is there a way to implement this behavior?Also, when you select a cell and click "backspace" it does not automatically delete the contents of the cell. Likewise, when you select a cell and click any key it does not override the current contents of the cell with the new key text. Is it possible to implement this excel-like behavior?Your help is greatly appreciated.Thanks!

Sindhu Nagarajan · Answer

Hi Travis, 


Thanks for using Syncfusion Products. 





Query  

Response 


To apply to an argument in a formula, like you can do in excel.  Is there a way to implement this behavior? 

We regret to let you know that GridControl does not have support to apply arguments or range of cells while typing formula in cell. As per the current support, when formula cell lost the focus, the formula computation will be initiated automatically. 


when you select a cell and click any key it does not override the current contents of the cell with the new key text. 

It can be achieved by setting ActivateCurrentCellBehavior as DblClickOnCell. 
Please refer to the below code, 
 
Code Example 
gridControl1.ActivateCurrentCellBehavior = GridCellActivateAction.DblClickOnCell; 
 
Note:  
To achieve this scenario with formula cell also, set ForceEditWhenActivated as False with above code customization. 

Code snippet: 
GridFormulaCellRenderer.ForceEditWhenActivated = false; 
 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/F1370271034653860 
 
Please let us know if you have any other queries. 

Regards, 
Sindhu

Query	Response
To apply to an argument in a formula, like you can do in excel. Is there a way to implement this behavior?	We regret to let you know that GridControl does not have support to apply arguments or range of cells while typing formula in cell. As per the current support, when formula cell lost the focus, the formula computation will be initiated automatically.
when you select a cell and click any key it does not override the current contents of the cell with the new key text.	It can be achieved by setting ActivateCurrentCellBehavior as DblClickOnCell. Please refer to the below code, Code Example gridControl1.ActivateCurrentCellBehavior = GridCellActivateAction.DblClickOnCell; Note: To achieve this scenario with formula cell also, set ForceEditWhenActivated as False with above code customization. Code snippet: GridFormulaCellRenderer.ForceEditWhenActivated = false;