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

Filters on multiple spreadsheet columns

3 Answers 89 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Callam
Top achievements
Rank 1
Veteran
Callam asked on 01 Nov 2019, 08:20 AM

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

3 Answers, 1 is accepted

Sort by
0
Aleksandar
Telerik team
answered on 04 Nov 2019, 04:39 PM

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

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.
0
Callam
Top achievements
Rank 1
Veteran
answered on 21 Nov 2019, 01:47 PM

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?

0
Aleksandar
Telerik team
answered on 25 Nov 2019, 10:46 AM

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:

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

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.
Tags
Spreadsheet
Asked by
Callam
Top achievements
Rank 1
Veteran
Answers by
Aleksandar
Telerik team
Callam
Top achievements
Rank 1
Veteran
Share this question
or