\Kendo\UI\SpreadsheetSheetFilter
A PHP class representing the filter setting of SpreadsheetSheet.
Methods
addColumn
Adds one or more SpreadsheetSheetFilterColumn to the SpreadsheetSheetFilter.
Returns
\Kendo\UI\SpreadsheetSheetFilter
Parameters
$value[, $value2, ...] \Kendo\UI\SpreadsheetSheetFilterColumn|array
Example - using \Kendo\UI\SpreadsheetSheetFilterColumn
<?php
$filter = new \Kendo\UI\SpreadsheetSheetFilter();
$column = new \Kendo\UI\SpreadsheetSheetFilterColumn();
$filter = 'value';
$column->filter($filter);
$filter->addColumn($column);
?>
Example - using array
<?php
$filter = new \Kendo\UI\SpreadsheetSheetFilter();
$filter = 'value';
$filter->addColumn(array('filter' => $filter));
?>
Example - adding more than one SpreadsheetSheetFilterColumn
<?php
$filter = new \Kendo\UI\SpreadsheetSheetFilter();
$first = new \Kendo\UI\SpreadsheetSheetFilterColumn();
$second = new \Kendo\UI\SpreadsheetSheetFilterColumn();
$filter->addColumn($first, $second);
?>
ref
The active range for the filter, for example, B1:D8.
Returns
\Kendo\UI\SpreadsheetSheetFilter
Parameters
$value string
Example
<?php
$filter = new \Kendo\UI\SpreadsheetSheetFilter();
$filter->ref('value');
?>