<kendo:spreadsheet-sheet-row-cell-validation>

The validation rule that is applied to the cell.

Example

<kendo:spreadsheet-sheet-row-cell>
    <kendo:spreadsheet-sheet-row-cell-validation></kendo:spreadsheet-sheet-row-cell-validation>
</kendo:spreadsheet-sheet-row-cell>

Configuration Attributes

allowNulls boolean

Specifies whether to allow null values.

Example

<kendo:spreadsheet-sheet-row-cell-validation allowNulls="allowNulls">
</kendo:spreadsheet-sheet-row-cell-validation>

comparerType java.lang.String

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.

Example

<kendo:spreadsheet-sheet-row-cell-validation comparerType="comparerType">
</kendo:spreadsheet-sheet-row-cell-validation>

dataType java.lang.String

Defines the data type of the cell value.The supported values are: date; text; number; list or custom.

Example

<kendo:spreadsheet-sheet-row-cell-validation dataType="dataType">
</kendo:spreadsheet-sheet-row-cell-validation>

from java.lang.String

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.

Example

<kendo:spreadsheet-sheet-row-cell-validation from="from">
</kendo:spreadsheet-sheet-row-cell-validation>

messageTemplate java.lang.String

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}.

Example

<kendo:spreadsheet-sheet-row-cell-validation messageTemplate="messageTemplate">
</kendo:spreadsheet-sheet-row-cell-validation>

showButton boolean

A Boolean value which indicates if a button for selecting list items will be displayed (dataType set to list).

Example

<kendo:spreadsheet-sheet-row-cell-validation showButton="showButton">
</kendo:spreadsheet-sheet-row-cell-validation>

titleTemplate java.lang.String

Defines the hint title that will be displayed if the value is invalid.

Example

<kendo:spreadsheet-sheet-row-cell-validation titleTemplate="titleTemplate">
</kendo:spreadsheet-sheet-row-cell-validation>

to java.lang.String

Defines a formula or a value that is used for the comparison process. Will be used if the comparer type requires a second argument.

Example

<kendo:spreadsheet-sheet-row-cell-validation to="to">
</kendo:spreadsheet-sheet-row-cell-validation>

type java.lang.String

Defines the validation type.The supported options are: reject or warning (default).

Example

<kendo:spreadsheet-sheet-row-cell-validation type="type">
</kendo:spreadsheet-sheet-row-cell-validation>