Kendo.Mvc.UI.Fluent.SpreadsheetSheetRowCellValidationSettingsBuilder

Defines the fluent API for configuring SpreadsheetSheetRowCellValidationSettings

Methods

Type(System.String)

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

Parameters

value System.String

The value for Type

ComparerType(System.String)

Defines the comparer type used to validate the cell value. Can be "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. Can be "date", "text", "number", "list" or "custom".

Parameters

value System.String

The value for DataType

From(System.String)

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

Parameters

value System.String

The value for 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 for ShowButton

ShowButton

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

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 for To

AllowNulls(System.Boolean)

Specifies whether to allow nulls.

Parameters

value System.Boolean

The value for 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 for 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

templateId System.String

The ID of the template element for MessageTemplate

TitleTemplate(System.String)

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

Parameters

value System.String

The value for TitleTemplate

TitleTemplateId(System.String)

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

Parameters

templateId System.String

The ID of the template element for TitleTemplate