5.20193.637
FlexSheetFilter Wijmo API Class

FlexSheetFilter Class

Implements an Excel-style filter for FlexSheet controls.

To enable filtering on a FlexSheet control, create an instance of the FlexSheetFilter and pass the grid as a parameter to the constructor.

Heirarchy

Constructors

constructor

Properties

activeEditor

activeEditor: ColumnFilterEditor

Gets the active ColumnFilterEditor.

This property allows you to customize the filter editor when handling the filterChanging event. It returns null when no filters are being edited.

defaultFilterType

defaultFilterType: FilterType

Gets or sets the default filter type to use.

This value can be overridden in filters for specific columns. For example, the code below creates a filter that filters by conditions on all columns except the "ByValue" column:

var f = new wijmo.grid.filter.FlexGridFilter(flex);
f.defaultFilterType = wijmo.grid.filter.FilterType.Condition;
var col = flex.columns.getColumn('ByValue'),
    cf = f.getColumnFilter(col);
cf.filterType = wijmo.grid.filter.FilterType.Value;

The default value for this property is FilterType.Both.

exclusiveValueSearch

exclusiveValueSearch: boolean

Gets or sets a value that determines whether the filter should include only values selected by the ValueFilter.filterText property.

This property is set to true by default, which matches Excel's behavior.

Set it to false to disable this behavior, so searching only affects which items are displayed on the list and not which items are included in the filter.

filterColumns

filterColumns: string[]

Gets or sets an array containing the names or bindings of the columns that have filters.

Setting this property to null or to an empty array adds filters to all columns.

filterDefinition

filterDefinition: string

Gets or sets the current filter definition as a JSON string.

grid

grid: FlexGrid

Gets a reference to the FlexGrid that owns this filter.

showFilterIcons

showFilterIcons: boolean

Gets or sets a value indicating whether the FlexGridFilter adds filter editing buttons to the grid's column headers.

If you set this property to false, then you are responsible for providing a way for users to edit, clear, and apply the filters.

The default value for this property is true.

showSortButtons

showSortButtons: boolean

Gets or sets a value indicating whether the filter editor should include sort buttons.

By default, the editor shows sort buttons like Excel does. But since users can sort columns by clicking their headers, sort buttons in the filter editor may not be desirable in some circumstances.

The default value for this property is true.

Methods

apply

  • apply(): void

clear

  • clear(): void

closeEditor

  • closeEditor(): void

editColumnFilter

getColumnFilter

onFilterApplied

onFilterChanged

onFilterChanging

Events

filterApplied

filterApplied: Event<FlexGridFilter, EventArgs>

Occurs after the filter is applied.

filterChanged

Occurs after a column filter has been edited by the user.

Use the event parameters to determine the column that owns the filter and whether changes were applied or canceled.

filterChanging

Occurs when a column filter is about to be edited by the user.

Use this event to customize the column filter if you want to override the default settings for the filter.

For example, the code below sets the operator used by the filter conditions to 'contains' if they are null:

filter.filterChanging.addHandler(function (s, e) {
  var cf = filter.getColumnFilter(e.col);
  if (!cf.valueFilter.isActive && cf.conditionFilter.condition1.operator == null) {
    cf.filterType = wijmo.grid.filter.FilterType.Condition;
    cf.conditionFilter.condition1.operator = wijmo.grid.filter.Operator.CT;
  }
});