ReoGrid icon indicating copy to clipboard operation
ReoGrid copied to clipboard

filter columns issues

Open vks2 opened this issue 5 years ago • 3 comments

Dear jingwood,

Thanks for your useful work. Few issues with filtering columns:

  1. Filtering or sorting columns do not affect column adjacent columns. If i sort column in a table like Excel I suppose that all columns will be filtered upon the values of 1 selected filtered column
  2. Do you think about more complicated sorting mechanics? Please see AdvancedDataGridView on gihub. They group dates in filter and allows searching in filtering mechanics. Very useful, Excel does it too.

All the best for you, your project and family.

Vladimir

vks2 avatar Feb 12 '20 08:02 vks2

@vks2 Hi! The SortColumn method has a parameter applyRange. I will try it after.

jingwood avatar Feb 18 '20 02:02 jingwood

Dear jingwood, And what about sorting? Now only one columns sorts from a to z, not Range, and there's no method ApplyRange. What we can do? Only raise an event .RowsSorted and then manually do LINQ with select all columns, sort by one of them (where sort button is clicked) and refresh grid? Thank you in advance!

vks2 avatar Feb 19 '20 11:02 vks2

As I've tried the filter feature some more in my investigation of WPF implementation I've stumbled upon some unexpected behavior:

The filter does not update automatically when changing the values. The rows are not removed from the grid, merely hidden, which causes range updates to overwrite the hidden values: reogrid-filter

ottosson avatar Feb 14 '22 10:02 ottosson