Cell edition and selection like Excel

[seb]

By default, by clicking on a cell, we select it and enter the edit mode.
I would like to disable this behavior : on a click I want to select the cell and I want to enter the edit mode on the double click.

What is the best way to do this?

Thanks in advance,
Sebastien

[Administrator]

You set the grid.ActivateCurrentCellBehavior property to control the behavior as you activate a cell.

[Lars Madsen]

In the sample FormulaCellSelection, provided by you,

ActivateCurrentCellBehavior seems only to apply to the cells in the grid that are not of type "FormulaCell", the FormulaCell cells always
go into edit mode when clicked on (not when using the keyboard), and even if you set

this.gridControl1.ActivateCurrentCellBehavior = GridCellActivateAction.DblClickOnCell;

this does not change anything

[Administrator]

Try also setting the static property:

GridFormulaCellRenderer.ForceEditWhenActivated = false;

[Lars Madsen]

Thanks, that worked well

On a related note, is there a way to not have to press enter twice when entering a formula like =5*A3

where you have used the keyboard to navigate to A3?

(i.e once to unselect A3 and once to calculate)

(If you look at Excel, you can see that it sets the cursor at the end of the text and only requires one enter press)

[Administrator]

There are no property settings to manage this.

You can try commenting out the code in teh keys.Enter case in the controller class in grid_CurrentCellKeyDown:

case Keys.Enter:
//		if(inKeyMove)
//		{
//			inKeyMove = false;
//			e.Handled = true;
//			PlaceTextInCell(ResetSelectionAfterPlacement);
//			CancelMode();
//			return;
//		}

	break;