Edit this page

clearFilter

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

Parameters

indexes Number |Array

The column index(es)

Example

<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>
Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy