Kendo.Mvc.UI.SpreadsheetSheetRowCellValidationSettings

Kendo UI SpreadsheetSheetRowCellValidationSettings class

Properties

Type

Defines the validation type. The acceptable options are reject or warning. Defaults to warning.

ComparerType

Defines the comparer type used to validate the cell value. Can be "greaterThan", "lessThan", "between", "equalTo", "notEqualTo", "greaterThanOrEqualTo", "lessThanOrEqualTo", "notBetween" or "custom".

DataType

Defines the data type of the cell value. Can be "date", "text", "number", "list" or "custom".

From

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.

ShowButton

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

To

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

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