\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');
?>