Kendo.Mvc.UI.SpreadsheetSheetRowCellValidationSettings

Kendo UI SpreadsheetSheetRowCellValidationSettings class

Properties

Type

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

ComparerType

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.

DataType

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

From

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.

ShowButton

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

To

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

AllowNulls

Specifies whether to allow null values.

MessageTemplate

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

MessageTemplateId

The id of the script element used for MessageTemplate

TitleTemplate

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

TitleTemplateId

The id of the script element used for TitleTemplate

Methods

SerializeSettings

Serialize current instance to Dictionary

In this article
Not finding the help you need?