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.
VNVignesh Natarajan Syncfusion Team December 14, 2018 02:41 AM
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.