Has anyone tried to implement the following scenario? I would be interested to know what solutions exist for this. This has become a real pain for our users ...
We have a DataGrid WPF that gives the user the ability to filter their rows of data based on a column (where Column = Value or Begins With, Ends With, Contains, etc. etc.). They can also sort the data by clicking on one of the column headings, or we also provide them with a sorting window in which they can add several columns and select ascending / descending for each column (which simply applies to the SortDirection property on each column they select, it also seems to use "CollectionView" along with SortDescriptions).
The problem is that the user edits the data and uses “filter” or “sort” (or both), if the user edits the value on one of these filtered / sorted columns, the row will “move” and take the cursor along with it. If the new value is “filtered”, then the string will completely disappear (as it should be, due to the “filtering” applied by the user).
They would like one of two things to happen instead:
1. Go ahead and automatically sort and filter after changing each cell, if the row "moves", move the cursor to the next row (the same cell) instead of the cursor following the row, to a new task (and, possibly, scrolling the current visible data rows from the screen).
2 - As soon as the line is edited, turn off all sorting and filtering until the user types “Save” or “Update” (or some other option)?
I can also see where we can use one approach for filtering and another for sorting.
Does anyone have a better idea or have ideas on how to implement this?
(, : CellEditEnding , , Save/ Reset , , "" "e.handled" true, ?). WPF DataGrid, , " " , , "DisableSorting = true/false" (lol).
? ?