init
The constructor of the filter.
Parameters
options Object
An object which should have a type field set to:
"belowAverage","aboveAverage","bottomPercent", or"bottomNumber"for numbers."tomorrow","today","yesterday","nextWeek","thisWeek","lastWeek","nextMonth","thisMonth","lastMonth","nextQuarter","thisQuarter",
"lastQuarter", "nextYear", "thisYear", "lastYear", "yearToDate" for date fields. "quarter1", "quarter2", "quarter3", "quarter4" and month (en-US) names are also accepted.
Example - aboveAverage
<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 ],
[ 1, 3, 9 ],
[ 1, 3, 9 ]
];
sheet.range("A1:C6").values(values);
var filter = new kendo.spreadsheet.DynamicFilter({ type: "aboveAverage" });
sheet.range("A1:C6").filter([ { column: 0, filter: filter } ]);
</script>Example - filter a range with dates
<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" ],
[ new Date(), 5, 6 ],
[ new Date(2000, 10, 10), 8, 9 ],
];
sheet.range("A1:C6").values(values);
var filter = new kendo.spreadsheet.DynamicFilter({ type: "today" });
sheet.range("A1:C6").filter([ { column: 0, filter: filter } ]);
</script>In this article