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

SpreadsheetSheetFilterSettingsColumnBuilder

Methods

Criteria(System.Action)

An array of filter criteria for custom filters.

Parameters

configurator - System.Action<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

In this article
Not finding the help you need?