New to Kendo UI for jQuery? Start a free 30-day trial

ClearFilter

methods

Clears the filters for the passed column index. If an array is passed, clearFilter will clear the filter for each column index.

clearFilter

Parameters:indexesNumber|Array

The column index(es)

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

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

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

    var sheet = spreadsheet.activeSheet();

    sheet.range("A1:B2").values([
        [1, 2],
        [2, 3]
    ]).filter({
        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.
</script>