Kendo.Mvc.UI.Fluent.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?