PSPavithra Subramaniyam Syncfusion Team June 17, 2019 04:38 AM
Thanks for contacting Syncfusion support.
By default, Excel filter works for complex filtering but filterBar does not work for complex predicate and it handle only single value in Grid. When dynamically change to filter type then it does not generate predicate based on that type because we have already generated the predicate for those filtered columns. We suggest you to clear the filter before changing the filter type to resolve the problem.