Kendo.Mvc.UI.Fluent.SpreadsheetSheetFilterSettingsColumnBuilder

Defines the fluent API for configuring SpreadsheetSheetFilterSettingsColumn

Methods

Criteria(System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetSheetFilterSettingsColumnCriteriaFactory>)

An array of filter criteria for custom filters.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetSheetFilterSettingsColumnCriteriaFactory>

The configurator for the criteria setting.

Filter(System.String)

The filter to apply to this column.The supported filters are: * value - filters based on unique values * custom - applies custom filtering criteria * top - filters the top or bottom records * dynamic - filters based on dynamic criteria

Parameters

value System.String

The value for Filter

Index(System.Double)

The index of the column relative to the filter range.

Parameters

value System.Double

The value for Index

Logic(System.String)

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

Parameters

value System.String

The value for Logic

Type(System.String)

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

Parameters

value System.String

The value for Type

Value(System.Double)

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

Parameters

value System.Double

The value for Value

Values(System.Object[])

The filter values for filters that support multiple values.

Parameters

value System.Object[]

The value for Values