This is a migrated thread and some comments may be shown as answers.

Disable Filter by value option in kendo spreadsheet filter

1 Answer 86 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Akash
Top achievements
Rank 1
Akash asked on 30 Mar 2021, 09:24 AM
I have a kendo spreadsheet with 1000 rows. It has a column with 1000 unique values. When I tried to give filter option to the column, the filter menu takes time to get displayed. It works fine with columns that have less values. This might have been due to the 1000 options that get displayed in the 'Filter by value' section. Is there any way to disable the Filter by value section and have only the Filter by condition section.

1 Answer, 1 is accepted

Sort by
0
Aleksandar
Telerik team
answered on 02 Apr 2021, 07:58 AM

Hi Akash,

The Spreadsheet does not provide a configuration option that would allow you to conditionally hide the Filter by values option for a given column. A possible approach you can consider is to hide this option for all columns using CSS, however this would hide the Filter by values option for all columns:

.k-spreadsheet-value-filter.k-details{
      display:none;
    }

We have a Feature Request on exposing a filter event for the Spreadsheet https://feedback.telerik.com/kendo-jquery-ui/1428867-add-filter-event-to-spreadsheet-api and I have voted on it on your behalf, as the desired behavior should be achievable if such an event handler is available.

Let me know if I can be of any further help.

Regards,
Aleksandar
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
Spreadsheet
Asked by
Akash
Top achievements
Rank 1
Answers by
Aleksandar
Telerik team
Share this question
or