Excel Like Filtering

[Adrian Loughman]

Hi All

 I am wondering if there is a way of changing the filtering to look more like the current version/s of excel.

The file grid.jpg is what the radgrid gives me, whereas the excel.jpg shows how to select multiple months, and select key ranges (this month, last month, between, etc).

 

Would i be able to replicate this with the gridview?

 

Also how can i change the filter logos so they are more visible when a column has a filter applied?

 

Ade

[Dess | Tech Support Engineer, Principal]

Hello Adrian,

Thank you for writing.

You can use the RadGridView.FilterPopupRequired event and specify the FilterPopupRequiredEventArgs.FilterPopup property. The FilterPopupRequired event is thrown just before filter pop up showing. It gives access to the current filter pop up through FilterPopup argument and also allows setting up any custom made pop up, which implements IGridFilterPopup interface. In order to show date values grouped by year and month in a list you can show a RadListFilterPopup:

public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
        this.radGridView1.EnableFiltering = true;
        this.radGridView1.ShowHeaderCellButtons = true;
        this.radGridView1.FilterPopupRequired+=radGridView1_FilterPopupRequired;
    }

    private void radGridView1_FilterPopupRequired(object sender, Telerik.WinControls.UI.FilterPopupRequiredEventArgs e)
    {
        if (e.Column.Name == "OrderDate")
        {
            e.FilterPopup = new Telerik.WinControls.UI.RadListFilterPopup(e.Column, true);
        }
    }

Please refer to the Excel-like filtering help article >> Customizing Excel-like filtering popup section. 

I hope this information helps. Should you have further questions, I would be glad to help.

 

Regards,
Dess
Telerik

[Martin]

Has the FilterPopupRequired event been removed recently? Because I can't seem to find it for my RadGridView in WPF

[Dess | Tech Support Engineer, Principal]

Hello, Martin,

I would like to note that this forum is related to RadGridView from the Telerik UI for WinForms suite. Hence, the provided solution is valid for the WinForms product.

If you have any technical questions regarding WPF, feel free to post in the relevant forum and thus the appropriate community would gladly assist you: https://www.telerik.com/forums 

Thank you for your understanding.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik