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

SpreadsheetDynamicFilterBuilder

Class

Defines the fluent API for configuring the SpreadsheetSheetFilterSettingsColumn settings.

Definition

Namespace:Kendo.Mvc.UI.Fluent

Assembly:Kendo.Mvc.dll

Syntax:

public class SpreadsheetDynamicFilterBuilder

Inheritance: objectSpreadsheetDynamicFilterBuilder

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

Constructors

SpreadsheetDynamicFilterBuilder(SpreadsheetSheetFilterSettingsColumn)

public SpreadsheetDynamicFilterBuilder(SpreadsheetSheetFilterSettingsColumn settings)

Parameters:settingsSpreadsheetSheetFilterSettingsColumn

Methods

Index(double)

The index of the column relative to the filter range.

public SpreadsheetDynamicFilterBuilder Index(double value)

Parameters:valuedouble

The value that configures the index.

Returns:

SpreadsheetDynamicFilterBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add().Name("Sheet1").Filter(filter =&gt; filter.Columns(fc =&gt; fc.DynamicFilter(df =&gt; df.Index(1))));
})
)

Type(SpreadsheetDynamicFilterType)

The filter sub-type, if any.Applicable types according to the main filter. * aboveAverage * belowAverage * tomorrow * today * yesterday * nextWeek * thisWeek * lastWeek * nextMonth * thisMonth * lastMonth * nextQuarter * thisQuarter * lastQuarter * nextYear * thisYear * lastYear * yearToDate

public SpreadsheetDynamicFilterBuilder Type(SpreadsheetDynamicFilterType value)

Parameters:valueSpreadsheetDynamicFilterType

The value that configures the type.

Returns:

SpreadsheetDynamicFilterBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add().Name("Sheet1").Filter(filter =&gt; filter.Columns(fc =&gt; fc.DynamicFilter(df =&gt; df.Type(SpreadsheetDynamicFilterType.ThisMonth))));
})
)