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 that will 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. or 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 that will apply to filter criteria.The supported values are: and or or.

Parameters

value System.String

The value for Logic

Type(System.String)

The filter sub-type, if any.The applicable types according to the main filter are: toptopNumbertopPercentbottomNumberbottomPercent or dynamicaboveAveragebelowAveragetomorrowtodayyesterdaynextWeekthisWeeklastWeeknextMonththisMonthlastMonthnextQuarterthisQuarterlastQuarternextYearthisYearlastYearyearToDate.

Parameters

value System.String

The value for Type

Value(System.Double)

The filter value for filters that require a single value, for example, 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