\Kendo\UI\SpreadsheetSheetRowCellValidation

A PHP class representing the validation setting of SpreadsheetSheetRowCell.

Methods

allowNulls

Specifies whether to allow nulls.

Returns

\Kendo\UI\SpreadsheetSheetRowCellValidation

Parameters

$value boolean

Example

<?php
$validation = new \Kendo\UI\SpreadsheetSheetRowCellValidation();
$validation->allowNulls(true);
?>

comparerType

Defines the comparer type used to validate the cell value, e.g. "greaterThan", "between" and etc.

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.

Returns

\Kendo\UI\SpreadsheetSheetRowCellValidation

Parameters

$value string

Example

<?php
$validation = new \Kendo\UI\SpreadsheetSheetRowCellValidation();
$validation->dataType('value');
?>

from

Defines a formula or value used for the comparison process. Used as only if comparer type does not require second argument.

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 value is invalid.The template is giving an access to the following variables: from{0}, to{1}, fromFormula{2}, toFormula{3}, dataType{4}, type{5} and comparerType{6}.

Returns

\Kendo\UI\SpreadsheetSheetRowCellValidation

Parameters

$value string

Example

<?php
$validation = new \Kendo\UI\SpreadsheetSheetRowCellValidation();
$validation->messageTemplate('value');
?>

showButton

A boolean value indicating if a button for selecting list items (dataType set to list) should be displayed.

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 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 value used for the comparison process. Will be used if comparer type requires 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 acceptable options are reject or warning

Returns

\Kendo\UI\SpreadsheetSheetRowCellValidation

Parameters

$value string

Example

<?php
$validation = new \Kendo\UI\SpreadsheetSheetRowCellValidation();
$validation->type('value');
?>
Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy