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

SpreadsheetValueFilterBuilder

Class

Defines the fluent API for configuring the SpreadsheetSheetFilterSettingsColumn settings.

Definition

Namespace:Kendo.Mvc.UI.Fluent

Assembly:Kendo.Mvc.dll

Syntax:

public class SpreadsheetValueFilterBuilder

Inheritance: objectSpreadsheetValueFilterBuilder

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

Constructors

SpreadsheetValueFilterBuilder(SpreadsheetSheetFilterSettingsColumn)

public SpreadsheetValueFilterBuilder(SpreadsheetSheetFilterSettingsColumn settings)

Parameters:settingsSpreadsheetSheetFilterSettingsColumn

Methods

Index(double)

The index of the column relative to the filter range.

public SpreadsheetValueFilterBuilder Index(double value)

Parameters:valuedouble

The value that configures the index.

Returns:

SpreadsheetValueFilterBuilder

Example:

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

Values(params object[])

The filter values for filters that support multiple values.

public SpreadsheetValueFilterBuilder Values(params object[] value)

Parameters:valueobject[]

The value that configures the values.

Returns:

SpreadsheetValueFilterBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Filter(filter =&gt; filter.Columns(col =&gt; col.ValueFilter(vf =&gt; vf.Values(new int[] { 100, 200 }))))
})
)