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
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.
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
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.
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
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.
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
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.
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
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.
ShowButton()
A Boolean value which indicates if a button for selecting list items will be displayed (dataType set to list).
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.
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
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.
AllowNulls(System.Boolean)
Specifies whether to allow null values.
Parameters
value - System.Boolean
The value for AllowNulls
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.
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
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.
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
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.
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
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.
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
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.
MessageTemplate(Kendo.Mvc.UI.Fluent.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.
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.
TitleTemplate(System.String)
Defines the hint title that will be displayed if the value is invalid.
Parameters
value - System.String
The value for TitleTemplate
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.
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
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.
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
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.
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
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.
TitleTemplate(Kendo.Mvc.UI.Fluent.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.
RETURNS
Returns the current SpreadsheetSheetRowCellValidationSettingsBuilder instance.