clearFilter

Clears the set filters for the given column(s). The indices is relative to the beginning of the range.

Parameters

indices Array | Number

The column(s) which filters should be cleared.

Example - clear the filters for a column

    <div id="spreadsheet"></div>


    <script type="text/javascript" charset="utf-8">

        $("#spreadsheet").kendoSpreadsheet();

        var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");

        var sheet = spreadsheet.activeSheet();

        var values = [
            [ "C 1", "C 2", "C 3" ],
            [ 7, 5, 6 ],
            [ 7, 8, 9 ],
            [ 6, 3, 9 ]
        ];

        sheet.range("A1:C4").values(values);

        var filter = new kendo.spreadsheet.ValueFilter({ values: [ 7 ] });
        var filter2 = new kendo.spreadsheet.ValueFilter({ values: [ 8 ] });

        sheet.range("A1:C4").filter([
          { column: 0, filter: filter },
            { column: 1, filter: filter2 }
        ]);

        // row 3 will be visible now.

        sheet.range("A1:C3").clearFilter([ 1 ]);
        // the filter on B column will be cleared, so rows 2 and 3 will be visible.
    </script>



In this article
Not finding the help you need?