Search results

FilterCollection API in JavaScript (ES5) Spreadsheet API control

Represents the Filter Collection.

Properties

column

number[]

Specifies the filtered column collection.

Defaults to []

criteria

string[]

Specifies the condition for column filtering.

Defaults to []

dataType

string[]

Specifies the data type of column filtering.

Defaults to []

filterRange

string

Specifies the range of the filter collection.

Defaults to []

hasFilter

boolean

Specifies the sheet has filter or not.

Defaults to false

predicates

string[]

Specifies the predicate type of column filtering.

Defaults to []

sheetIndex

number

Specifies the sheet index of the filter collection.

Defaults to null

value

[]

Specifies the value for column filtering.

Defaults to []