Hello, Jean-Marc,
Let me please explain in details how the editing mechanism in
RadGridView works. By default, no editor is available in the grid. If you double click a cell or press F2 when a certain cell is selected,
RadGridView activates the relevant editor for that cell and
RadGridView enters edit mode. After you enter the desired value in the editor you can commit the value by pressing the Enter key or navigate to another cell. Pressing the Escape key will cancel the edit operation. Note that once the editor's value is committed, the underlying
DataBoundItem is updated accordingly. This is the designed behavior. Have in mind that once the grid is sorted by a certain column, it orders the rows considering the applied
SortDescriptor and the cells' values belonging to this column. The
SortDescriptor is responsible for keeping the available rows sorted according to the applied criteria. That is why when you add a new row or edit an existing one, they are placed at the correct index according to the applied sorting.
A possible solution is to use the custom sorting functionality where you can fully manage how the rows are ordered:
https://docs.telerik.com/devtools/winforms/gridview/sorting/custom-sorting. Alternatively,
RadGridView allows you to prevent the built-in data sorting operation but keep the sorting life cycle as it is, e.g. UI indication,
SortDescriptors and events remain. This is controlled by the MasterTemplate.DataView.BypassSort property which default value is false. This means that
RadGridView won't perform the sorting if you set it to true. This may be suitable for cases in which you bound the grid to a
DataTable and you want to apply the sort direction to the
DataTable, not to the grid itself. A sample code snippet is available in the following help article:
https://docs.telerik.com/devtools/winforms/gridview/sorting/basic-sorting
I hope this information helps. If you have any additional questions, please let me know.
Regards,
Dess
Progress Telerik