SpreadsheetSheetRowCellValidationSettingsBuilder
Methods
Type(System.String)
Defines the validation type.The supported options are: reject or warning (default).
Parameters
value - System.String
The value for Type
ComparerType(System.String)
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.
Parameters
value - System.String
The value for ComparerType
DataType(System.String)
Defines the data type of the cell value.The supported values are: date; text; number; list or custom.
Parameters
value - System.String
The value for DataType
From(System.String)
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.
Parameters
value - System.String
The value for From
ShowButton(System.Boolean)
A Boolean value which indicates if a button for selecting list items will be displayed (dataType set to list).
Parameters
value - System.Boolean
The value for ShowButton
ShowButton()
A Boolean value which indicates if a button for selecting list items will be displayed (dataType set to list).
To(System.String)
Defines a formula or a value that is used for the comparison process. Will be used if the comparer type requires a second argument.
Parameters
value - System.String
The value for To
AllowNulls(System.Boolean)
Specifies whether to allow null values.
Parameters
value - System.Boolean
The value for AllowNulls
MessageTemplate(System.String)
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}.
Parameters
value - System.String
The value for MessageTemplate
MessageTemplateId(System.String)
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}.
Parameters
templateId - System.String
The ID of the template element for MessageTemplate
MessageTemplateView(Microsoft.AspNetCore.Html.IHtmlContent)
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}.
Parameters
templateView - Microsoft.AspNetCore.Html.IHtmlContent
The view that contains the template for MessageTemplate
MessageTemplateHandler(System.String)
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}.
Parameters
templateHandler - System.String
The handler that returs the template for MessageTemplate
MessageTemplate(Kendo.Mvc.UI.TemplateBuilder)
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}.
Parameters
template - TemplateBuilder<TModel>
A Template component that configures the messagetemplate.
TitleTemplate(System.String)
Defines the hint title that will be displayed if the value is invalid.
Parameters
value - System.String
The value for TitleTemplate
TitleTemplateId(System.String)
Defines the hint title that will be displayed if the value is invalid.
Parameters
templateId - System.String
The ID of the template element for TitleTemplate
TitleTemplateView(Microsoft.AspNetCore.Html.IHtmlContent)
Defines the hint title that will be displayed if the value is invalid.
Parameters
templateView - Microsoft.AspNetCore.Html.IHtmlContent
The view that contains the template for TitleTemplate
TitleTemplateHandler(System.String)
Defines the hint title that will be displayed if the value is invalid.
Parameters
templateHandler - System.String
The handler that returs the template for TitleTemplate
TitleTemplate(Kendo.Mvc.UI.TemplateBuilder)
Defines the hint title that will be displayed if the value is invalid.
Parameters
template - TemplateBuilder<TModel>
A Template component that configures the titletemplate.