Excel Like Filtering

7 posts, 0 answers
  1. Sudeep
    Sudeep avatar
    2 posts
    Member since:
    Dec 2010

    Posted 22 Feb 2011 Link to this post

    hi all

    Is there a way to display the distinct values calculated after each column is filtered and I only want the value that still remain in the view?

  2. Richard Slade
    Richard Slade avatar
    3000 posts
    Member since:
    May 2009

    Posted 22 Feb 2011 Link to this post

    Hello Sudeep,

    If my understanding of your issue is correct, you have a RadgridView, which you you both standard and excel like filtering on. If you type something into the standard filter, you are not seeing this reflected in the excel like filter. Is that correct?

    If so, I have tried this with the latest Q3 2010 SP1 version and could not replicate your issue. In a GridViewDecimalColumn, I had several integer values. I added the following code

    this.radGridView1.EnableFiltering = true;
    this.radGridView1.ShowFilteringRow = true;
    this.radGridView1.ShowHeaderCellButtons = true;

    And then I set the standard filter, by typing into the filter area 1. After clicking the excel like filter button, I saw this was reflected in the criteria. Please see the attached screenshots.

    If you are not on the latest version, i'd suggest upgrading. If you are, then please post a sample that replicates this and I'll take a look at it for you
    Thanks
    Richard
  3. UI for WinForms is Visual Studio 2017 Ready
  4. Sudeep
    Sudeep avatar
    2 posts
    Member since:
    Dec 2010

    Posted 22 Feb 2011 Link to this post

    Hello Richard
    After i use a filter on 'MID' column in my grid, i sholud see only those 'TID' which are associted with the MID as displayed on the grid.
    But my filter contains all the 'TID's which were loaded initially in the grid.
    How to get rid of this?
  5. Richard Slade
    Richard Slade avatar
    3000 posts
    Member since:
    May 2009

    Posted 22 Feb 2011 Link to this post

    Hello Sudeep,

    As far as I know that isn't supported. When you perform an equals filter by typing into a filter, it can search through the values in that column and sets the appropriate checkboxes in the excel like filter. But my guess is, that if it had to do this for every row, and then for every column performance would start to suffer. Because you have only chosen to filter by one column, the other filters are unaffected.
    Regards,
    Richard
  6. Martin Vasilev
    Admin
    Martin Vasilev avatar
    1061 posts

    Posted 24 Feb 2011 Link to this post

    Hello guys,

    Actually, Sudeep has a valid point here and we are considering to include this functionality: to filter the values in Excel-Like filtering popup, according to the applied filtering on other columns. We will include this in one of the next releases, however I cannot give a time frame for this yet.

    Kind regards,
    Martin Vasilev
    the Telerik team
    Registration for Q1 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting March 21st and book your seat for a walk through all the exciting stuff we ship with the new release!
  7. Sandi Markon
    Sandi Markon avatar
    101 posts
    Member since:
    Jul 2012

    Posted 20 Apr 2012 Link to this post

    Hello everybody,

    Has any progress been made regarding this issue? Or maybe there's a convenient workaround for this?

    I'm thiking, if there would be an event, which fires evertime, the excel-like filtering dialog is popped up, then I could programatically pick up the currently displayed column values (by use of the ChildRows property) and fill the filter dialog with the filtered values.

    Thanks in advance,
    S
  8. Jack
    Admin
    Jack avatar
    2335 posts

    Posted 25 Apr 2012 Link to this post

    Hi Sandi Markon,

    This feature is still not in our plans. However, I added it in our public issue tracking system. This way you and the other users can vote for it and if there is high interest in it, we will consider raising its priority. Use the following link to vote for this feature. 

    Meanwhile, there is an event which you can use to manually check the desired nodes for the desired columns. Attached you can find a sample implementation.

    Let us know if you have any other questions.
     
    Regards,
    Jack
    the Telerik team
    RadControls for WinForms Q1'12 release is now live! Check out what's new or download a free trial >>
Back to Top
UI for WinForms is Visual Studio 2017 Ready