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.

AllowNulls

Specifies whether to allow nulls.

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

MessageTemplateId

The id of the script element used for MessageTemplate

TitleTemplate

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

TitleTemplateId

The id of the script element used for TitleTemplate

Methods

SerializeSettings

Serialize current instance to Dictionary