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