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

SpreadsheetSheetFilterSettingsColumnCriteriaBuilder

Class

Defines the fluent API for configuring the SpreadsheetSheetFilterSettingsColumnCriteria settings.

Definition

Namespace:Kendo.Mvc.UI.Fluent

Assembly:Kendo.Mvc.dll

Syntax:

public class SpreadsheetSheetFilterSettingsColumnCriteriaBuilder

Inheritance: objectSpreadsheetSheetFilterSettingsColumnCriteriaBuilder

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

Constructors

SpreadsheetSheetFilterSettingsColumnCriteriaBuilder(SpreadsheetSheetFilterSettingsColumnCriteria)

public SpreadsheetSheetFilterSettingsColumnCriteriaBuilder(SpreadsheetSheetFilterSettingsColumnCriteria settings)

Parameters:settingsSpreadsheetSheetFilterSettingsColumnCriteria

Methods

Operator(SpreadsheetFilterOperator)

The criterion operator type.Supported types vary based on the inferred column data type (inferred):

Text
- contains - the text contains the value
- doesnotcontain - text does not contain the value
- startswith - text starts with the value
- endswith - text ends with the value
Date
- eq - date is the same as the value
- neq - date is not the same as the value
- lt - date is before the value
- gt - date is after the value
Number
- eq - is equal to the value
- neq - is not equal to the value
- gte - is greater than or equal to the value
- gt - is greater than the value
- lte - is less than or equal to the value
- lt - is less than the value

public SpreadsheetSheetFilterSettingsColumnCriteriaBuilder Operator(SpreadsheetFilterOperator value)

Parameters:valueSpreadsheetFilterOperator

The value that configures the operator.

Returns:

SpreadsheetSheetFilterSettingsColumnCriteriaBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Filter(filter =&gt;
filter.Columns(col =&gt;
col.CustomFilter(cf =&gt;
cf.Criteria(criteria =&gt;
criteria.Add(cr =&gt;
cr.Operator(SpreadsheetFilterOperator.Contains))))));
})
)

Value(DateTime)

The value for the criteria operator.

public SpreadsheetSheetFilterSettingsColumnCriteriaBuilder Value(DateTime value)

Parameters:valueDateTime

The value that configures the value.

Returns:

SpreadsheetSheetFilterSettingsColumnCriteriaBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Filter(filter =&gt;
filter.Columns(col =&gt;
col.CustomFilter(cf =&gt;
cf.Criteria(criteria =&gt;
criteria.Add(cr =&gt;
cr.Value(new DateTime(2024, 4, 16)))))));
})
)

Value(double)

The value for the criteria operator.

public SpreadsheetSheetFilterSettingsColumnCriteriaBuilder Value(double value)

Parameters:valuedouble

The value that configures the value.

Returns:

SpreadsheetSheetFilterSettingsColumnCriteriaBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Filter(filter =&gt;
filter.Columns(col =&gt;
col.CustomFilter(cf =&gt;
cf.Criteria(criteria =&gt;
criteria.Add(cr =&gt;
cr.Value(110))))));
})
)

Value(string)

The value for the criteria operator.

public SpreadsheetSheetFilterSettingsColumnCriteriaBuilder Value(string value)

Parameters:valuestring

The value that configures the value.

Returns:

SpreadsheetSheetFilterSettingsColumnCriteriaBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Filter(filter =&gt;
filter.Columns(col =&gt;
col.CustomFilter(cf =&gt;
cf.Criteria(criteria =&gt;
criteria.Add(cr =&gt;
cr.Value("food"))))));
})
)