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

SpreadsheetTopFilterBuilder

Class

Defines the fluent API for configuring the SpreadsheetSheetFilterSettingsColumn settings.

Definition

Namespace:Kendo.Mvc.UI.Fluent

Assembly:Kendo.Mvc.dll

Syntax:

public class SpreadsheetTopFilterBuilder

Inheritance: objectSpreadsheetTopFilterBuilder

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

Constructors

SpreadsheetTopFilterBuilder(SpreadsheetSheetFilterSettingsColumn)

public SpreadsheetTopFilterBuilder(SpreadsheetSheetFilterSettingsColumn settings)

Parameters:settingsSpreadsheetSheetFilterSettingsColumn

Methods

Index(double)

The index of the column relative to the filter range.

public SpreadsheetTopFilterBuilder Index(double value)

Parameters:valuedouble

The value that configures the index.

Returns:

SpreadsheetTopFilterBuilder

Example:

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

Type(SpreadsheetTopFilterType)

The filter sub-type, if any.Applicable types according to the main filter. * TopNumber * TopPercent * BottomNumber * BottomPercent

public SpreadsheetTopFilterBuilder Type(SpreadsheetTopFilterType value)

Parameters:valueSpreadsheetTopFilterType

The value that configures the type.

Returns:

SpreadsheetTopFilterBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Filter(filter =&gt; filter.Columns(col =&gt; col.TopFilter(tf =&gt; tf.Type(SpreadsheetTopFilterType.BottomNumber))));
})
)

Value(double)

The filter value for filters that require a single value, e.g. "top".

public SpreadsheetTopFilterBuilder Value(double value)

Parameters:valuedouble

The value that configures the value.

Returns:

SpreadsheetTopFilterBuilder

Example:

@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =&gt;
{
sheets.Add()
.Name("Food Order")
.Filter(filter =&gt; filter.Columns(col =&gt; col.TopFilter(tf =&gt; tf.Value(100))));
})
)