Kendo.Mvc.UI.SpreadsheetSheetFilterSettingsColumn

Kendo UI SpreadsheetSheetFilterSettingsColumn class

Properties

Criteria

An array of filter criteria for custom filters.

Filter

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

Index

The index of the column relative to the filter range.

Logic

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

Type

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

Value

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

Values

The filter values for filters that support multiple values.

Methods

SerializeSettings

Serialize current instance to Dictionary