Filters on multiple spreadsheet columns

[Callam]

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.

 

Callam

[Aleksandar]

Hello Callam,

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.

Regards,
Aleksandar
Progress Telerik

[Callam]

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?

[Aleksandar]

Hi Callam,

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:

• https://feedback.telerik.com/kendo-jquery-ui/1443622-implement-between-filter-option-for-numeric-values-in-spreadsheet  

We will monitor the interest in this feature and based on the demand for such an integration, this might be scheduled for research in future versions of Kedno UI. 

Regards,
Aleksandar
Progress Telerik