FilterColumn

FilterColumn class

Represents a filter for a single column. The Filter object is a member of the Filters collection

class FilterColumn;

Methods

MethodDescription
isDropdownVisible()Indicates whether the AutoFilter button for this column is visible.
setIsDropdownVisible(boolean)Indicates whether the AutoFilter button for this column is visible.
getFilter()Gets and sets the condition of filtering data.
setFilter(object)Gets and sets the condition of filtering data.
getFilterType()Gets and sets the type fo filtering data.
setFilterType(FilterType)Gets and sets the type fo filtering data.
getFieldIndex()Gets and sets the column offset in the range.
setFieldIndex(number)Gets and sets the column offset in the range.

isDropdownVisible()

Indicates whether the AutoFilter button for this column is visible.

isDropdownVisible() : boolean;

setIsDropdownVisible(boolean)

Indicates whether the AutoFilter button for this column is visible.

setIsDropdownVisible(value: boolean) : void;

Parameters:

ParameterTypeDescription
valuebooleanThe value to set.

getFilter()

Gets and sets the condition of filtering data.

getFilter() : object;

setFilter(object)

Gets and sets the condition of filtering data.

setFilter(value: object) : void;

Parameters:

ParameterTypeDescription
valueobjectThe value to set.

getFilterType()

Gets and sets the type fo filtering data.

getFilterType() : FilterType;

Returns

FilterType

setFilterType(FilterType)

Gets and sets the type fo filtering data.

setFilterType(value: FilterType) : void;

Parameters:

ParameterTypeDescription
valueFilterTypeThe value to set.

getFieldIndex()

Gets and sets the column offset in the range.

getFieldIndex() : number;

setFieldIndex(number)

Gets and sets the column offset in the range.

setFieldIndex(value: number) : void;

Parameters:

ParameterTypeDescription
valuenumberThe value to set.