Edit this page

Kendo.Mvc.UI.Fluent.SpreadsheetSheetRowCellValidationSettingsBuilder

Defines the fluent API for configuring the SpreadsheetSheetRowCellValidationSettings settings.

Methods

Type(System.String)

Defines the validation type. The acceptable options are reject or warning

Parameters

value System.String

The value that configures the type.

ComparerType(System.String)

Defines the comparer type used to validate the cell value, e.g. "greaterThan", "between" and etc.

Parameters

value System.String

The value that configures the comparertype.

DataType(System.String)

Defines the data type of the cell value.

Parameters

value System.String

The value that configures the datatype.

From(System.String)

Defines a formula or value used for the comparison process. Used as only if comparer type does not require second argument.

Parameters

value System.String

The value that configures the from.

ShowButton(System.Boolean)

A boolean value indicating if a button for selecting list items (dataType set to list) should be displayed.

Parameters

value System.Boolean

The value that configures the showbutton.

To(System.String)

Defines a formula or value used for the comparison process. Will be used if comparer type requires second argument.

Parameters

value System.String

The value that configures the to.

AllowNulls(System.Boolean)

Specifies whether to allow nulls.

Parameters

value System.Boolean

The value that configures the allownulls.

MessageTemplate(System.String)

Defines the hint message that will be displayed if value is invalid.The template is giving an access to the following variables: from{0}, to{1}, fromFormula{2}, toFormula{3}, dataType{4}, type{5} and comparerType{6}.

Parameters

value System.String

The value that configures the messagetemplate.

MessageTemplateId(System.String)

Defines the hint message that will be displayed if value is invalid.The template is giving an access to the following variables: from{0}, to{1}, fromFormula{2}, toFormula{3}, dataType{4}, type{5} and comparerType{6}.

Parameters

value System.String

The value that configures the messagetemplate.

TitleTemplate(System.String)

Defines the hint title that will be displayed if 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 value is invalid.

Parameters

value System.String

The value that configures the titletemplate.