Spreadsheet - How to clear applied filters?

2 posts, 0 answers
  1. Michael
    Michael avatar
    29 posts
    Member since:
    Jun 2015

    Posted 05 Jun 2019 Link to this post

    We are using kendo spreadsheet with more than one sheets, wants the functionality to clear applied filters in the spreadsheet. I couldn't find any documentations for that, please helps us to fix this issue. Thanks
  2. Dimitar
    Dimitar avatar
    809 posts

    Posted 07 Jun 2019 Link to this post

    Hello Michael,

    If I can understand correctly, you have a filter set on a column that you would like to programmatically clear. If this is the case, then you could use the Spreadsheet Sheet's clearFilter() method:
    <div id="spreadsheet"></div>
    <script type="text/javascript" charset="utf-8">
        var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
        var sheet = spreadsheet.activeSheet();
            [1, 2],
            [2, 3]
            column: 1,
            filter: new kendo.spreadsheet.ValueFilter({
                values: [2]
        }); // the filter will hide the second row
        sheet.clearFilter(1); // the clear filter will remove the applied filter for the second column.

    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.
Back to Top