Filter Column - non sequential

2 posts, 0 answers
  1. Jeff
    Jeff avatar
    5 posts
    Member since:
    Jan 2011

    Posted 13 Jul Link to this post

    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 => { });


        .Filter(filter =>

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


       .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




  2. Veselin Tsvetanov
    Veselin Tsvetanov avatar
    278 posts

    Posted 15 Jul Link to this post

    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.

    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
  3. UI for ASP.NET MVC is VS 2017 Ready
Back to Top