\Kendo\UI\SpreadsheetSheetRowCellValidation
A PHP class representing the validation setting of SpreadsheetSheetRowCell.
Methods
allowNulls
Specifies whether to allow null values.
Returns
\Kendo\UI\SpreadsheetSheetRowCellValidation
Parameters
$value boolean
Example
<?php
$validation = new \Kendo\UI\SpreadsheetSheetRowCellValidation();
$validation->allowNulls(true);
?>
comparerType
Defines the comparer type that is used to validate the cell value.The supported values are: greaterThan; lessThan; between; equalTo; notEqualTo; greaterThanOrEqualTo; lessThanOrEqualTo; notBetween or custom.
Returns
\Kendo\UI\SpreadsheetSheetRowCellValidation
Parameters
$value string
Example
<?php
$validation = new \Kendo\UI\SpreadsheetSheetRowCellValidation();
$validation->comparerType('value');
?>
dataType
Defines the data type of the cell value.The supported values are: date; text; number; list or custom.
Returns
\Kendo\UI\SpreadsheetSheetRowCellValidation
Parameters
$value string
Example
<?php
$validation = new \Kendo\UI\SpreadsheetSheetRowCellValidation();
$validation->dataType('value');
?>
from
Defines a formula or a value that is used for the comparison process. Used as the only compare value if the comparer type does not require a second argument. Mandatory for validation to work.
Returns
\Kendo\UI\SpreadsheetSheetRowCellValidation
Parameters
$value string
Example
<?php
$validation = new \Kendo\UI\SpreadsheetSheetRowCellValidation();
$validation->from('value');
?>
messageTemplate
Defines the hint message that will be displayed if the value is invalid.The template provides access to the following variables: from{0}; to{1}; fromFormula{2}; toFormula{3}; dataType{4}; type{5} or comparerType{6}.
Returns
\Kendo\UI\SpreadsheetSheetRowCellValidation
Parameters
$value string
Example
<?php
$validation = new \Kendo\UI\SpreadsheetSheetRowCellValidation();
$validation->messageTemplate('value');
?>
showButton
A Boolean value which indicates if a button for selecting list items will be displayed (dataType set to list).
Returns
\Kendo\UI\SpreadsheetSheetRowCellValidation
Parameters
$value boolean
Example
<?php
$validation = new \Kendo\UI\SpreadsheetSheetRowCellValidation();
$validation->showButton(true);
?>
titleTemplate
Defines the hint title that will be displayed if the value is invalid.
Returns
\Kendo\UI\SpreadsheetSheetRowCellValidation
Parameters
$value string
Example
<?php
$validation = new \Kendo\UI\SpreadsheetSheetRowCellValidation();
$validation->titleTemplate('value');
?>
to
Defines a formula or a value that is used for the comparison process. Will be used if the comparer type requires a second argument.
Returns
\Kendo\UI\SpreadsheetSheetRowCellValidation
Parameters
$value string
Example
<?php
$validation = new \Kendo\UI\SpreadsheetSheetRowCellValidation();
$validation->to('value');
?>
type
Defines the validation type.The supported options are: reject or warning (default).
Returns
\Kendo\UI\SpreadsheetSheetRowCellValidation
Parameters
$value string
Example
<?php
$validation = new \Kendo\UI\SpreadsheetSheetRowCellValidation();
$validation->type('value');
?>