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
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Problems with Excel Filter

Thread ID:





141484 Dec 13,2018 04:15 PM UTC Dec 17,2018 06:58 AM UTC ASP.NET Core 3
Tags: Grid
Asked On December 13, 2018 04:15 PM UTC

The Excel filter is not functioning correctly.

When we have few possible values for a column, these should be shown in the filter dialog box along with their respective checkbox, but that not always happen.

In my case, I have two possible values but in the filter dialog only appears one, and if I apply a custom search (contains...) then the other value appears. But if I deselect and select once again both values, when I click Ok, the second value disappears. As a result the Grid control shows an inadequate results.

I have attached a video that shows this behavior.

Attachment: gridexcelfiltererrors_30965876_46fea95a.zip

Vignesh Natarajan [Syncfusion]
Replied On December 14, 2018 07:41 AM UTC

Hi Eduardo, 

Thanks for contacting Syncfusion Support. 

We can reproduce your reported problem at our end. While using the UrlAdaptor of DataManager, Grid collects the data from the server according to the PageSettings property of  current PageSize  or using default PageSize and loads the data based on loadOnDemand concept. In Excel Filter, we will show only distinct values from the first 1000 records of Grid dataSource. In your dataSource, you have bound nearly 10000 records, so that it will return first 1000 records with distinct values.  

Kindly refer the below link for the Knowledge base document to overcome the reported issue.  

Vignesh Natarajan. 


Replied On December 14, 2018 06:10 PM UTC

Thanks for your response.
Now it works!

Vignesh Natarajan [Syncfusion]
Replied On December 17, 2018 06:58 AM UTC

Hi Eduardo, 

Thanks for the update. 

We are glad to hear that you query has been resolved by our solution  

Please get back to us if you have further queries. 

Vignesh Natarajan   


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

Live Chat Icon For mobile
Live Chat Icon