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. Image for the cookie policy date

No rows seem to match when using GridExcelFilter on GridGroupingControl


I am having an issue when I used the GridExcelFilter as the column filter for my GridGroupingControl. When I used the filter to select any column value...then no rows are displayed at all!

I have attached a simple example where I have:
* Populated a GridGroupingControl with a List<T>
* Enabled AllowFilter for each of the columns
* Wired up a GridExcelFilter to the GridGroupingControl

See attached zip file (GroupingGridWithExcelFilters.zip)

When I run the application, filter on a column value, no rows are displayed at all.

Can someone please explain to me why the rows are not filtered according to the chosen filter value?


Attachment: GroupingGridWithExcelFilters_6298e7b5.zip

3 Replies

NK Neelakandan Kannan Syncfusion Team June 5, 2015 04:55 AM UTC

Hi Stephen,


Thank you for using Syncfusion products.


We can also reproduce your reported scenario at our end. The reported issue with “Filtering not performed has been occurred due to the MappingName and Name properties of the ColumnDescriptor. If you want to set the Name property for the column descriptor, the name should be like MappingName. For more details, please refer the below description for the MappingName and Name properties.


MappingName description:


Name description:


Here we have provided the modified sample and code snippet. Please make use of it.


Code Snippet:

gridColumnDescriptor1.MappingName = "ColumnAField";

//The name and mapping name should be same when you specify the name for column

gridColumnDescriptor1.Name = "ColumnAField";


gridColumnDescriptor2.MappingName = "ColumnBField";

//The name and mapping name should be same when you specify the name for column

gridColumnDescriptor2.Name = "ColumnBField";


Modified Sample:



Please let me know if you have any concerns.




SN Stephen New June 5, 2015 06:51 AM UTC

Thanks very much, Neelakandan. That solved my problem.

NK Neelakandan Kannan Syncfusion Team June 5, 2015 06:58 AM UTC

Hi Stephen,

Thank you for your update.

We are glad to hear from you that your scenario has been achieved.

Please let us know if you need further assistance on this.


Live Chat Icon For mobile
Up arrow icon