Kendo.Mvc.UI.Fluent.SpreadsheetSheetRowCellValidationSettingsBuilder

Defines the fluent API for configuring the SpreadsheetSheetRowCellValidationSettings settings.

Methods

Type(System.String)

Defines the validation type.The supported options are: reject or warning (default).

Parameters

value System.String

The value that configures the 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 that configures the 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 that configures the 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 that configures the 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 that configures the showbutton.

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 that configures the to.

AllowNulls(System.Boolean)

Specifies whether to allow null values.

Parameters

value System.Boolean

The value that configures the 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 that configures the 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

value System.String

The value 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 that configures the titletemplate.

TitleTemplateId(System.String)

Defines the hint title that will be displayed if the value is invalid.

Parameters

value System.String

The value that configures the titletemplate.

In this article
Not finding the help you need?