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

Columns filters not showing all available options: search not working

Hi Team, 

We need same support in angular platform, please refer the forum

https://www.syncfusion.com/forums/141605/columns-filters-not-showing-all-available-options-search-not-working




Regards,
Kumaresan S


4 Replies

PG Peter Groft November 15, 2022 03:45 AM

Excel Filter Not Working With Blank Rows

One very common problem with the Excel filter function is that it won’t work with the blank rows. Excel Filter doesn’t count the cells with the first blank spaces.


To fix this, you need to choose the range right before using the filter function. For a clearer idea of how to perform this task, check out the following example.

Before using the Excel filter function on column C. either you can choose column “C” completely or just select the data which you want to filter out.

From the “data” tab select the “Filter” option. Now all the items become visible in the filter checkbox list or filtered list.

Similarly, you have to choose the cell ranges or multiple columns before the application of the filter function.


Regards,
Peter



KU Kumaresan November 15, 2022 11:27 PM

HI Syncfusion Team,


Any updates?



KU Kumaresan November 17, 2022 01:44 AM

FYI,


This is bcz you guys doing query for 1st 1000 records so that iam facing this issue.


I have override your query through actoinbegin e



PS Pavithra Subramaniyam Syncfusion Team November 17, 2022 05:29 AM

Query#1: This is bcz you guys doing query for 1st 1000 records so that iam facing this issue.I have override your query through actoinbegin e


Yes, By default, the Excel/ Checkbox filter Dialog in the Grid will display the distinct data from the first 1000 records in grid dataSource to optimize the performance. You can increase the Excel filter choice count by modifying the filterChoiceCount argument value in the actionBegin event when the requestType is ‘filterchoicerequest’ as demonstrated in the below code snippet,


actionBegin(args){

  if(args.requestType == 'filterchoicerequest'){

 

 args.filterChoiceCount = 5000;   // change the filterchoicecount value as you need (the filter check list shown based on this value )

 }

}

 


If you are facing any issues with this solution in your angular application, please get back to us with more details, like Grid code example, Syncfusion package version, Screenshot of the issue, and a simple replication example which will be helpful for us to provide a better solution.


Query#2: Excel Filter Not Working With Blank Rows


Before validating the query, please share the below details which will be helpful for us to provide a better solution as early as possible.


  1. Share the Grid sample
  2. In which type of column (like string, number, date, boolean) you are facing the blank value filtering issue
  3. Share the Syncfusion package version
  4. “From the “data” tab select the “Filter” option.” – Share the UI for this scenario

Loader.
Live Chat Icon For mobile
Up arrow icon