<kendo:spreadsheet-sheet-filter-column>

An array defining the filter configuration of individual columns.

Example

<kendo:spreadsheet-sheet-filter-columns>
    <kendo:spreadsheet-sheet-filter-column></kendo:spreadsheet-sheet-filter-column>
</kendo:spreadsheet-sheet-filter-columns>

Configuration Attributes

filter java.lang.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

Example

<kendo:spreadsheet-sheet-filter-column filter="filter">
</kendo:spreadsheet-sheet-filter-column>

index float

The index of the column relative to the filter range.

Example

<kendo:spreadsheet-sheet-filter-column index="index">
</kendo:spreadsheet-sheet-filter-column>

logic java.lang.String

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

Example

<kendo:spreadsheet-sheet-filter-column logic="logic">
</kendo:spreadsheet-sheet-filter-column>

type java.lang.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

Example

<kendo:spreadsheet-sheet-filter-column type="type">
</kendo:spreadsheet-sheet-filter-column>

value java.lang.Object

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

Example

<kendo:spreadsheet-sheet-filter-column value="value">
</kendo:spreadsheet-sheet-filter-column>

Configuration JSP Tags

kendo:spreadsheet-sheet-filter-column-criteria

An array of filter criteria for custom filters.

More documentation is available at kendo:spreadsheet-sheet-filter-column-criteria.

Example

<kendo:spreadsheet-sheet-filter-column>
    <kendo:spreadsheet-sheet-filter-column-criteria></kendo:spreadsheet-sheet-filter-column-criteria>
</kendo:spreadsheet-sheet-filter-column>
Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy