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

SpreadsheetCustomFilterBuilder

Class

Defines the fluent API for configuring the SpreadsheetSheetFilterSettingsColumn settings.

Definition

Namespace:Kendo.Mvc.UI.Fluent

Assembly:Kendo.Mvc.dll

Syntax:

public class SpreadsheetCustomFilterBuilder

Inheritance: objectSpreadsheetCustomFilterBuilder

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

Constructors

SpreadsheetCustomFilterBuilder(SpreadsheetSheetFilterSettingsColumn)

public SpreadsheetCustomFilterBuilder(SpreadsheetSheetFilterSettingsColumn settings)

Parameters:settingsSpreadsheetSheetFilterSettingsColumn

Methods

Criteria(Action<SpreadsheetSheetFilterSettingsColumnCriteriaFactory>)

An array of filter criteria for custom filters.

public SpreadsheetCustomFilterBuilder Criteria(Action<SpreadsheetSheetFilterSettingsColumnCriteriaFactory> configurator)

Parameters:configuratorAction<SpreadsheetSheetFilterSettingsColumnCriteriaFactory>

The action that configures the criteria.

Returns:

SpreadsheetCustomFilterBuilder

Example:

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

Index(double)

The index of the column relative to the filter range.

public SpreadsheetCustomFilterBuilder Index(double value)

Parameters:valuedouble

The value that configures the index.

Returns:

SpreadsheetCustomFilterBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Filter(filter =&gt; filter.Columns(cols =&gt; cols.CustomFilter(cf =&gt; cf.Index(1))))
})
)

Logic(SpreadsheetFilterLogic)

The logical operator to apply to filter criteria.Possible values are and, or.

public SpreadsheetCustomFilterBuilder Logic(SpreadsheetFilterLogic value)

Parameters:valueSpreadsheetFilterLogic

The value that configures the logic.

Returns:

SpreadsheetCustomFilterBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Filter(filter =&gt; filter.Columns(cols =&gt; cols.CustomFilter(cf =&gt; cf.Logic(SpreadsheetFilterLogic.Or))))
})
)