<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, e.g. "greaterThan", "between" and etc.

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.

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 only if comparer type does not require second argument.

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

Example

<kendo:spreadsheet-sheet-row-cell-validation type="type">
</kendo:spreadsheet-sheet-row-cell-validation>
Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy