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

Sheets.filter

configuration

Defines the filtering criteria for this sheet, if any.

sheets.filter

Object

<div id="spreadsheet"></div>
<script>
  $("#spreadsheet").kendoSpreadsheet({
    sheets: [{
      filter: {
        ref: "A1:C10",
        columns: [
          { index: 0, type: "value", value: "John", filter: "custom", criteria: [{ value: "J", operator: "contains" }] }
        ]
      }
    }]
  });
</script>

sheets.filter.columns

Array

An array which defines the filter configuration of individual columns.

<div id="spreadsheet"></div>
<script>
  $("#spreadsheet").kendoSpreadsheet({
    sheets: [{
      filter: {
        ref: "A1:C10",
        columns: [
          { index: 0, type: "value", value: "Product A", filter: "custom", criteria: [{ value: "A", operator: "contains" }] },
          { index: 1, type: "custom", logic: "and", filter: "custom", criteria: [{ value: "A", operator: "contains" }] }
        ]
      }
    }]
  });
</script>

sheets.filter.ref

String

The active range for the filter, for example, B1:D8.

<div id="spreadsheet"></div>
<script>
  $("#spreadsheet").kendoSpreadsheet({
    sheets: [{
      filter: {
        ref: "A1:C10",
        columns: [{
          index: 0,
          type: "value",
          value: "Product",
          filter: "custom",
          criteria: [{ value: "A", operator: "contains" }]
        }]
      }
    }]
  });
</script>

Sheets.filter

sheets.filter

sheets.filter.columns

sheets.filter.ref

Related Members