Hello, I'm trying to get the grid editing to behave like Excel. I've seen numerous posts on this, but some are a few years old, so I'm wondering if it is supported now. I'm setting the following grid properties to get close to what I want:
radGrid.SelectionUnit = GridViewSelectionUnit.Cell;
radGrid.EditTriggers = GridViewEditTriggers.TextInput | GridViewEditTriggers.CurrentCellClick;
radGrid.SelectionMode = SelectionMode.Extended;
Specifically, I'm looking for the following behavior:
1. Select a cell. Start typing and the cell goes into edit mode. This works.
2. Select a cell. Single click the cell again causes the cell to go into edit. I would like the cell to go into edit mode on a double click, like Excel. Also, this causes a selection problem as well because if I mouse down in the already selected cell to do a multiple cell selection, I can't because the cell goes into edit. This is actually my biggest issue.
3. Press Enter key after edit causes the next cell to go into edit mode. I would like Enter to just move to the next cell without editing. This goes for the Tab key, and click another cell in the same row(clicking a cell in another row will not place that cell into edit mode). All place you into edit mode. Excel does not do this and this is the behavior I would like.
If there's a way to set properties to get the functionality I'm looking for, that would be great. Otherwise, any suggestions?
This post http://www.telerik.com/community/forums/wpf/gridview/cell-edit-mode.aspx discusses overriding the keyboard command provider. Is that what is recommended? It seems like editing like Excel would be functionality that should be built into the grid control.
Thanks,
Scott
radGrid.SelectionUnit = GridViewSelectionUnit.Cell;
radGrid.EditTriggers = GridViewEditTriggers.TextInput | GridViewEditTriggers.CurrentCellClick;
radGrid.SelectionMode = SelectionMode.Extended;
Specifically, I'm looking for the following behavior:
1. Select a cell. Start typing and the cell goes into edit mode. This works.
2. Select a cell. Single click the cell again causes the cell to go into edit. I would like the cell to go into edit mode on a double click, like Excel. Also, this causes a selection problem as well because if I mouse down in the already selected cell to do a multiple cell selection, I can't because the cell goes into edit. This is actually my biggest issue.
3. Press Enter key after edit causes the next cell to go into edit mode. I would like Enter to just move to the next cell without editing. This goes for the Tab key, and click another cell in the same row(clicking a cell in another row will not place that cell into edit mode). All place you into edit mode. Excel does not do this and this is the behavior I would like.
If there's a way to set properties to get the functionality I'm looking for, that would be great. Otherwise, any suggestions?
This post http://www.telerik.com/community/forums/wpf/gridview/cell-edit-mode.aspx discusses overriding the keyboard command provider. Is that what is recommended? It seems like editing like Excel would be functionality that should be built into the grid control.
Thanks,
Scott