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

The validation rule 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 nulls.

Example

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

comparerType java.lang.String

Defines the comparer type used to validate the cell value. Can be "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. Can be "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 value used for the comparison process. Used as the only compare value if comparer type does not require 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 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}.

Example

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

showButton boolean

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

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

Example

<kendo:spreadsheet-sheet-row-cell-validation type="type">
</kendo:spreadsheet-sheet-row-cell-validation>
In this article
Not finding the help you need?