init
The constructor of the filter.
Parameters
options Object
An object which may contain the following keys:
logic- string - either"and"or"or".criteria- an array of objects, containingoperator(String) andvalue(String|Date|Number) fields.
The supported criteria operators are: eq (equal to), neq (not equal to), lt (less than), lte (less than or equal to), gt (greater than), gte (greater than or equal to).
In addition, startswith, endswith, contains, doesnotstartwith and doesnotendwith are supported for cells that contain strings.
Example - custom filter
<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" ],
[ "John", 5, 6 ],
[ "Jane", 8, 9 ],
[ "Bruke", 3, 9 ]
];
sheet.range("A1:C4").values(values);
var filter = new kendo.spreadsheet.CustomFilter({
logic: "or",
criteria: [
{ operator: "startswith", value: "Jo" },
{ operator: "startswith", value: "Ja" }
]
});
sheet.range("A1:C4").filter([ { column: 0, filter: filter } ]);
</script>