Selecting in spreadsheet when only showing selected element
This issue was created automatically from an original Mantis Issue. Further discussion may take place here.
The selection behavior in the spreadsheet view is undesirable when the "Show only selected elements" feature is on. When this option is on and you select a row by clicking on it, suddenly all rows except the one just clicked on disappear because the selection has immediately changed. This behavior is both annoying (because it is easy to loose the current selection set) and unhelpful (because it is impossible to select more than one element).
There are many potential behaviors that are better than this. An acceptable solution is to simply disable selection in the spreadsheet view when showing only selected elements. A better behavior would be to allow selection, but to not change the rows viewed when they are selected from within the spreadsheet (only change them when the selection occurs within a different view or the selection inspector).