New to Telerik UI for ASP.NET Core? Download free 30-day trial

SpreadsheetSheetRowCellValidationSettingsBuilder

Defines the fluent API for configuring SpreadsheetSheetRowCellValidationSettings

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

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

In this article
Not finding the help you need?