By default, when changes are made to a sorted column resorting is done automatically in C1DataGrid. However in MS-Excel, resorting is not done, so the grid does not sort for modified values. Therefore, how to achieve excel like sorting in C1DataGrid.
Steps to Complete:
1. Handle grid’s BeganEdit event. Inside access the editor and further handle an editor’s event that triggers when its Value change (like ValueChanged event of C1NumericBox).
2. Use editor’s event to store the rows in the order they appear in the grid.
3. Store the rows back in the grid after editing is done. C1DataGrid’s CommittedEdit event can be used for this purpose.