1. Home
  2. Forum
  3. WinForms
  4. Limiting Filter Results for Excel-Like Filter in GGC

Limiting Filter Results for Excel-Like Filter in GGC

Hey guys!

I was wondering if there was a way you can limit the amount of results that are displayed when clicking on the filter icon for a column in a GridGroupingControl. I have a column with about 120,000 results and when clicking the filter icon (using Excel-like filter), it takes a long while to load because it shows all 120,000 entries in the filter window. 

1 Reply
MG Mohanraj Gunasekaran Syncfusion Team February 16, 2018 09:00 AM UTC

 Hi Wladimir, 

Thanks for using Syncfusion product. 
 
By default, ExcelFilter has load all the record from binding object so if you load more than 100000 record unique values, obviously it will take a time to load that values in excel filter popup. In our GridGroupingControl architecture, does not have the limitation to load the records in filter popup when click on the excel filter icon. 
 
Please let me know if you have any concerns. 
 
Regards, 
Mohanraj G 


Loader.
Up arrow icon