Is there any way to apply column filtering to multiple columns at once? Whenever I try to add a second filter, the first is erased.
Thanks for any help.
3 Answers, 1 is accepted
answered on 04 Nov 2019, 04:39 PM
This can be achieved by defining the filter property for the sheet.
filter.columns represents an array that defines the filter configuration for each individual column. You need to specify the criteria for the filter - an array of filter criteria for the custom filters. The criteria should contain an object, that provides the operator type and the value. The column array also needs information on the index to which the criteria are applied and a filter type.
In this dojo you will find the modified demo where Client column is filtered for customers with name containing "er" and Shipping columns containing "2".
I hope this helps. Let me know if you have further questions.
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers.Learn More.
Hi thanks for replying. So I take it multiple filters only work if implemented when the spreadsheet is created and that the user cannot add multiple filter?
As a follow up question, is it possible to filter between a range of values, like in Excel?E.g. 'filter out if not between 3 and 6'. As far as I can tell, it seems you can only filter ' if lower than 3' or 'if above 6', but you cannot specify a filtering range. Am I missing something?
answered on 25 Nov 2019, 10:46 AM
The user can also apply multiple filters. In the Basic Usage example once the data is selected and filters added for the columns the user can filter by multiple columns, see a demo screencast here.
Currently, there is no available option for the user to filter values that are in between a range. As a possible solution, the user can manually select the values that should be filtered. I have logged a Feature Request on your behalf on the Public Feedback portal and updated your Telerik Points accordingly: