Kendo.Mvc.UI.SpreadsheetSheetFilterSettingsColumn

Kendo UI SpreadsheetSheetFilterSettingsColumn class

Properties

Criteria

An array of filter criteria for custom filters.

Filter

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..

Index

The index of the column relative to the filter range.

Logic

The logical operator that will apply to filter criteria.The supported values are: and or or.

Type

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

Value

The filter value for filters that require a single value, for example, top.

Values

The filter values for filters that support multiple values.

Methods

SerializeSettings

Serialize current instance to Dictionary