Consider below example:
In Ultragrid if column 2 is dependent on Column 1 Values ,
and if we filter column 1 then column 2 get automatically filtered , -(this is correct)
but on click of "Filter" of Column 2 ,still we are able to access all values of column 2 (irrespective of value selected in column 1)
This is not as per default Excel filter bahaviour.
please suggest that how can we get default Excel filteration behaviour in Infragestics UltraGrid.
-Mayank.
I tested this out and it appears to work just fine for me. The second filter dropdown displays only values that are still visible in the list and not not contain any values that were filtered out as a result of the filter on the other column.
Perhaps you are using an old version of the grid that had a bug. Or maybe there is some setting that is changing this behavior, although I am unable to find any such setting.
Can you duplicate this in a small sample project?
HI Mike,
Thanks for quick response.
If we use default filter behavior then its working as expected (like excel) ,but
if we use UltraGridFilterUIProvider
then its not behaving like default Excel filtration .
please see below screenshot.
Here if we filter Department by "Admin", then it is filtering Employee list correctly, but in filter option of Employee its showing all employees.
Please suggest me the exact implementation..
Thanks,Mayank.
Hi Mayank,
Ah, okay, I see the same behavior now.
I am going to forward this thread to Infragistics Developer Support so they can look into this. This looks like a bug to me that will need to be fixed.
Can you provide me with some details, how to use UltraGridFilterUIProvider to show the same behaviour as shown in your above snapshot.
What i want is, how to get the checkbox dropdown for filtering (default filter behavior like excel).
Thanks in advance,
Amit
Hi Amit,
If you are using Infragistics version 9, then you can drag and drop the UltraGridFilterUIProvider from Toolbox onto your form. Then go to grid's Properties -> Display Layout -> Override -> FilterUIProvider and select the UltraGridFilterUIProvider from the dropdown.
Alternatively you can use this code:
private UltraGridFilterUIProvider filterUIProvider = null;
private void Form1_Load(object sender, EventArgs e)
{
this.filterUIProvider = new UltraGridFilterUIProvider();
this.ultraGrid1.DisplayLayout.Override.FilterUIProvider = this.filterUIProvider;
}