We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Excel Like Filtering Advance Filter's filter type drop down

Thread ID:





116459 May 28,2014 04:58 AM UTC Jun 2,2014 12:27 PM UTC WPF 1
Tags: SfDataGrid
Kevin Kuan
Asked On May 28, 2014 04:58 AM UTC


Can I know is there anyway i can populate the excel like filtering drop down with only the filter type I want.

Taking the example of Text Filters, there are Equals, Not Equals, BeginsWith, Contains, EndsWith, Empty, Not Empty, Null , Not Null.
How do i remove the empty, not empty, null and not null from the dropdown list?

Best Regard,

Saravanan C [Syncfusion]
Replied On June 2, 2014 12:27 PM UTC

Hi Kevin,


Thank you for contacting Syncfusion Support.


You can remove the null and not null filter types by setting the property AllowBlankFilter=”False” in grid column. Please refer the code sample in below:


Code Snippet[XAML]:


    <syncfusion:GridTextColumn MappingName="OrderID"




And also if you want to remove the empty and not empty filter types from advanced text filtering, then you can achieve this by editing the control template for AdvancedFilterControl and changing the items source of the PART_MenuComboBox1 and PART_MenuComboBox2 with your items source. We have created the sample based on your requirement, please find the sample in the attachments.


Please let us know the provided solution helps you.



Saravanan C

Attachment: ExcelLikeFilteringDemo_81c49ac1.zip


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon