init

The constructor of the filter.

Parameters

options Object

An object which may contain the following keys:

• type - String - can be "topPercent", "topNumber", "bottomPercent", or "bottomNumber".
• value - Number, the count | percentage of items to display.

Example - top 2 numbers

    <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" ],
            [1, 2, 3 ],
            [2, 3, 4 ],
            [3, 4, 5 ],
        ];

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

        var filter = new kendo.spreadsheet.TopFilter({ type: "topNumber", value: 2 });

        sheet.range("A1:C4").filter([ { column: 0, filter: filter } ]);
    </script>

Example - filter the top 50 percent of the items

    <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" ],
            [1, 2, 3 ],
            [2, 3, 4 ],
            [3, 4, 5 ],
            [4, 5, 6 ],
        ];

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

        var filter = new kendo.spreadsheet.TopFilter({ type: "topPercent", value: 50 });

        sheet.range("A1:C5").filter([ { column: 0, filter: filter } ]);
    </script>