Filtering like Excel

[John Thompson]

Is there an "out of the box" way to filter columns like Excel does?  In other words, I want the distinct values calculated after each column is filtered and I only want to see the value that still remain in the view.

[Rossen Hristov]

Hi John Thompson,

This Excel mode IS the out-of-the-box behavior. You can try it. I have attached a sample project. Filter by country. Choose only England. Then go to filter by Player. You will see that only English players are shown. So you do not have to do anything in order to have this -- it is the default mode.

In case you want to turn this behavior off and show ALL distinct values (i.e. anti-Excel) there is a way to do that as well. Here is how to turn filtering off:

private void playersGrid_DistinctValuesLoading(object sender, Telerik.Windows.Controls.GridView.GridViewDistinctValuesLoadingEventArgs e)
{
    var filterDistinctValues = false;
    e.ItemsSource = this.playersGrid.GetDistinctValues(e.Column, filterDistinctValues);
}

I have added this to the sample project as well. You can play around with it by uncommenting the code.

I hope this helps. Let me know if you have any other questions.

Kind regards,
Ross
the Telerik team

[John Thompson]

This surely does help... I have implemented the DistinctValuesLoading event handler and I had false as the second parameter to GetDistinctValues.  Changing this to true fixed my handler!  Many thanks!