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

Filter Column - non sequential

1 Answer 47 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Jeff
Top achievements
Rank 1
Jeff asked on 13 Jul 2016, 04:41 PM

I am trying to set the filer option for columns A to G and also column Q but cannot seem to get any syntax to work.

The below works for setting the filter option for columns A to G but when I try to also include Q I get an error or only column Q is filtered

   .Filter(filter =>
                {
                    filter.Ref("A1:G7000").Columns(columns => { });
                 })

Error

    .Filter(filter =>

                {
                    filter.Ref("A1:G7000;Q1:Q7000").Columns(columns => { });
                })

 

Error
   .Filter(filter =>
                {
                    filter.Ref("A1:G7000,Q1:Q7000").Columns(columns => { });
                })

 

Only Column Q is filterable

   .Filter(filter =>
                {
                    filter.Ref("A1:G7000).Columns(columns => { });
                    filter.Ref("Q1:Q7000").Columns(columns => { });

                })

 

Any help on the syntax would be appreciated

 

Jeff

 

1 Answer, 1 is accepted

Sort by
0
Veselin Tsvetanov
Telerik team
answered on 15 Jul 2016, 10:24 AM
Hello Jeff,

Thank you for contacting us.

Currently, the filter functionality of the Spreadsheet supports only one range at a time. You won't be able to configure the helper to filter both ranges A1:G7000 and Q1:Q7000.

I hope that the above answers your question. If you have any further questions, please do not hesitate to contact us.

Regards,
Veselin Tsvetanov
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Spreadsheet
Asked by
Jeff
Top achievements
Rank 1
Answers by
Veselin Tsvetanov
Telerik team
Share this question
or