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

No rows seem to match when using GridExcelFilter on GridGroupingControl

Thread ID:





119325 Jun 5,2015 01:49 AM UTC Jun 5,2015 06:58 AM UTC WinForms 3
Tags: GridGroupingControl
Stephen New
Asked On June 5, 2015 01:49 AM UTC


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

Neelakandan Kannan [Syncfusion]
Replied On 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.




Stephen New
Replied On June 5, 2015 06:51 AM UTC

Thanks very much, Neelakandan. That solved my problem.

Neelakandan Kannan [Syncfusion]
Replied On 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.



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