Spreadsheet Filtering

[Kevin]

I'm trying to filter a spreadsheet, and while it works, it is EXTREMELY slow

And this kind of makes sense - we have ~35k unique values in this SKU column - but clicking to add a filter and then clicking the down arrow takes 20+ seconds before the filter popup appears, during which time the whole screen is frozen

Is there a way to allow a filter by value without including this multi-select, as with the data we have, in its current form, its completely unusable.

Thanks

[Georgi Denchev]

Hi, Kevin,

The built-in filter of the Spreadsheet does not allow for the removal of the checkboxes. You could create your own filters or even your own custom filtering UI where you programmatically apply filters with the help of the API:

https://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/valuefilter/methods/init 

The only other alternative is to limit the filterable range:

                filter: {
                  ref: "A3:G22", // Limit filtering to A3:G22
                  columns:[]
                }

Best Regards,

Georgi