Excel Like Filtering

2 posts, 0 answers
  1. Adrian Loughman
    Adrian Loughman avatar
    18 posts
    Member since:
    Nov 2002

    Posted 15 Jul 2015 Link to this post

    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

  2.
  3. Dess
    Admin
    Dess avatar
    2101 posts

    Posted 16 Jul 2015 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top