New to Telerik UI for ASP.NET MVC? Start a free 30-day trial

SpreadsheetSheetRowCellValidationSettingsBuilder

Class

Defines the fluent API for configuring the SpreadsheetSheetRowCellValidationSettings settings.

Definition

Namespace:Kendo.Mvc.UI.Fluent

Assembly:Kendo.Mvc.dll

Syntax:

public class SpreadsheetSheetRowCellValidationSettingsBuilder

Inheritance: objectSpreadsheetSheetRowCellValidationSettingsBuilder

Inherited Members object.GetType()object.MemberwiseClone()object.ToString()object.Equals(object)object.Equals(object, object)object.ReferenceEquals(object, object)object.GetHashCode()...

Constructors

SpreadsheetSheetRowCellValidationSettingsBuilder(SpreadsheetSheetRowCellValidationSettings)

public SpreadsheetSheetRowCellValidationSettingsBuilder(SpreadsheetSheetRowCellValidationSettings settings)

Parameters:settingsSpreadsheetSheetRowCellValidationSettings

Methods

AllowNulls(bool)

Specifies whether to allow null values.

public SpreadsheetSheetRowCellValidationSettingsBuilder AllowNulls(bool value)

Parameters:valuebool

The value that configures the allownulls.

Returns:

SpreadsheetSheetRowCellValidationSettingsBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Rows(rows =&gt;
{
rows.Add()
.Cells(cells =&gt;
{
cells.Add()
.Value("John Doe")
.Validation(validation =&gt; validation.AllowNulls(true));
});
});
})
)

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.

public SpreadsheetSheetRowCellValidationSettingsBuilder ComparerType(string value)

Parameters:valuestring

The value that configures the comparertype.

Returns:

SpreadsheetSheetRowCellValidationSettingsBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Rows(rows =&gt;
{
rows.Add()
.Cells(cells =&gt;
{
cells.Add()
.Value("John Doe")
.Validation(validation =&gt; validation.ComparerType("list"));
});
});
})
)

DataType(string)

Defines the data type of the cell value.The supported values are: date; text; number; list or custom.

public SpreadsheetSheetRowCellValidationSettingsBuilder DataType(string value)

Parameters:valuestring

The value that configures the datatype.

Returns:

SpreadsheetSheetRowCellValidationSettingsBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Rows(rows =&gt;
{
rows.Add()
.Cells(cells =&gt;
{
cells.Add()
.Value("John Doe")
.Validation(validation =&gt; validation.DataType("custom"));
});
});
})
)

From(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.

public SpreadsheetSheetRowCellValidationSettingsBuilder From(string value)

Parameters:valuestring

The value that configures the from.

Returns:

SpreadsheetSheetRowCellValidationSettingsBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Rows(rows =&gt;
{
rows.Add()
.Cells(cells =&gt;
{
cells.Add()
.Value(20000)
.Validation(validation =&gt; validation.From("DATEVALUE(\"1/1/1990\")"));
});
});
})
)

MessageTemplate(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}.

public SpreadsheetSheetRowCellValidationSettingsBuilder MessageTemplate(string value)

Parameters:valuestring

The value that configures the messagetemplate.

Returns:

SpreadsheetSheetRowCellValidationSettingsBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Rows(rows =&gt;
{
rows.Add()
.Cells(cells =&gt;
{
cells.Add()
.Value("John Doe")
.Validation(validation =&gt; validation.MessageTemplate("The name should be longer than 3 letters and shorter than 200."));
});
});
})
)

MessageTemplate<TModel>(TemplateBuilder<TModel>)

public SpreadsheetSheetRowCellValidationSettingsBuilder MessageTemplate<TModel>(TemplateBuilder<TModel> template)

Parameters:templateTemplateBuilder<TModel>

A Template component that configures the messagetemplate.

Returns:

SpreadsheetSheetRowCellValidationSettingsBuilder

MessageTemplateHandler(string)

public SpreadsheetSheetRowCellValidationSettingsBuilder MessageTemplateHandler(string value)

Parameters:valuestring

The value that configures the messagetemplate.

Returns:

SpreadsheetSheetRowCellValidationSettingsBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Rows(rows =&gt;
{
rows.Add()
.Cells(cells =&gt;
{
cells.Add()
.Value("John Doe")
.Validation(validation =&gt; validation.MessageTemplateHandler("templateHandler"));
});
});
})
)

MessageTemplateId(string)

public SpreadsheetSheetRowCellValidationSettingsBuilder MessageTemplateId(string value)

Parameters:valuestring

The value that configures the messagetemplate.

Returns:

SpreadsheetSheetRowCellValidationSettingsBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Rows(rows =&gt;
{
rows.Add()
.Cells(cells =&gt;
{
cells.Add()
.Value("John Doe")
.Validation(validation =&gt; validation.MessageTemplateId("messageTemplate1"));
});
});
})
)

MessageTemplateView(MvcHtmlString)

public SpreadsheetSheetRowCellValidationSettingsBuilder MessageTemplateView(MvcHtmlString value)

Parameters:valueMvcHtmlString

The value that configures the messagetemplate.

Returns:

SpreadsheetSheetRowCellValidationSettingsBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Rows(rows =&gt;
{
rows.Add()
.Cells(cells =&gt;
{
cells.Add()
.Value("John Doe")
.Validation(validation =&gt; validation.MessageTemplateView(Html.Partial("SpreadsheetTemplateView")));
});
});
})
)

ShowButton(bool)

A Boolean value which indicates if a button for selecting list items will be displayed (dataType set to list).

public SpreadsheetSheetRowCellValidationSettingsBuilder ShowButton(bool value)

Parameters:valuebool

The value that configures the showbutton.

Returns:

SpreadsheetSheetRowCellValidationSettingsBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Rows(rows =&gt;
{
rows.Add()
.Cells(cells =&gt;
{
cells.Add()
.Value("John Doe")
.Validation(validation =&gt; validation.ShowButton(true));
});
});
})
)

TitleTemplate(string)

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

public SpreadsheetSheetRowCellValidationSettingsBuilder TitleTemplate(string value)

Parameters:valuestring

The value that configures the titletemplate.

Returns:

SpreadsheetSheetRowCellValidationSettingsBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Rows(rows =&gt;
{
rows.Add()
.Cells(cells =&gt;
{
cells.Add()
.Value("John Doe")
.Validation(validation =&gt; validation.TitleTemplate("Full Name validation error"));
});
});
})
)

TitleTemplate<TModel>(TemplateBuilder<TModel>)

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

public SpreadsheetSheetRowCellValidationSettingsBuilder TitleTemplate<TModel>(TemplateBuilder<TModel> template)

Parameters:templateTemplateBuilder<TModel>

A Template component that configures the titletemplate.

Returns:

SpreadsheetSheetRowCellValidationSettingsBuilder

TitleTemplateHandler(string)

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

public SpreadsheetSheetRowCellValidationSettingsBuilder TitleTemplateHandler(string value)

Parameters:valuestring

The value that configures the titletemplate.

Returns:

SpreadsheetSheetRowCellValidationSettingsBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Rows(rows =&gt;
{
rows.Add()
.Cells(cells =&gt;
{
cells.Add()
.Value("John Doe")
.Validation(validation =&gt; validation.TitleTemplateHandler("titleTemplateHandler"));
});
});
})
)

TitleTemplateId(string)

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

public SpreadsheetSheetRowCellValidationSettingsBuilder TitleTemplateId(string value)

Parameters:valuestring

The value that configures the titletemplate.

Returns:

SpreadsheetSheetRowCellValidationSettingsBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Rows(rows =&gt;
{
rows.Add()
.Cells(cells =&gt;
{
cells.Add()
.Value("John Doe")
.Validation(validation =&gt; validation.TitleTemplateId("titleTemplate1"));
});
});
})
)

TitleTemplateView(MvcHtmlString)

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

public SpreadsheetSheetRowCellValidationSettingsBuilder TitleTemplateView(MvcHtmlString value)

Parameters:valueMvcHtmlString

The value that configures the titletemplate.

Returns:

SpreadsheetSheetRowCellValidationSettingsBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Rows(rows =&gt;
{
rows.Add()
.Cells(cells =&gt;
{
cells.Add()
.Value("John Doe")
.Validation(validation =&gt; validation.TitleTemplateView(Html.Partial("TitleTemplateView")));
});
});
})
)

To(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.

public SpreadsheetSheetRowCellValidationSettingsBuilder To(string value)

Parameters:valuestring

The value that configures the to.

Returns:

SpreadsheetSheetRowCellValidationSettingsBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Rows(rows =&gt;
{
rows.Add()
.Cells(cells =&gt;
{
cells.Add()
.Value(20000)
.Validation(validation =&gt; validation.To("DATEVALUE(\"1/1/1998\")"));
});
});
})
)

Type(string)

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

public SpreadsheetSheetRowCellValidationSettingsBuilder Type(string value)

Parameters:valuestring

The value that configures the type.

Returns:

SpreadsheetSheetRowCellValidationSettingsBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Rows(rows =&gt;
{
rows.Add()
.Cells(cells =&gt;
{
cells.Add()
.Value("John Doe")
.Validation(validation =&gt; validation.Type("reject"));
});
});
})
)