aspose.cells

Classes

Constants

Class FilterColumn

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

Property Getters/Setters Summary
`function`	`getColorFilter()`

`function`	`getCustomFilters()`
`function`	`setCustomFilters(value)`

`function`	`getDynamicFilter()`

`function`	`getFieldIndex()`
`function`	`setFieldIndex(value)`
	Gets and sets the column offset in the range.
`function`	`getFilter()`
`function`	`setFilter(value)`
	Gets and sets the condition of filtering data.
`function`	`getFilterType()`
`function`	`setFilterType(value)`
	Gets and sets the type fo filtering data. The value of the property is FilterType integer constant.
`function`	`getFilterValues()`

`function`	`getIconFilter()`

`function`	`isDropdownVisible()`
`function`	`setDropdownVisible(value)`
	Indicates whether the AutoFilter button for this column is visible.
`function`	`getMultipleFilters()`
`function`	`setMultipleFilters(value)`

`function`	`getTop10Filter()`

Method Summary
`function`	`selectAll()`
`function`

- Property Getters/Setters Detail
  - isDropdownVisible/setDropdownVisible : boolean
```
function isDropdownVisible() / function setDropdownVisible(value)
```
    Indicates whether the AutoFilter button for this column is visible.
  - getFilter/setFilter : Object
```
function getFilter() / function setFilter(value)
```
    Gets and sets the condition of filtering data.
  - getFilterType/setFilterType : Number
```
function getFilterType() / function setFilterType(value)
```
    Gets and sets the type fo filtering data. The value of the property is FilterType integer constant.
  - getFilterValues : FilterValueCollection
```
function getFilterValues()
```
  - getMultipleFilters/setMultipleFilters : MultipleFilterCollection
```
function getMultipleFilters() / function setMultipleFilters(value)
```
  - getCustomFilters/setCustomFilters : CustomFilterCollection
```
function getCustomFilters() / function setCustomFilters(value)
```
  - getColorFilter : ColorFilter
```
function getColorFilter()
```
  - getDynamicFilter : DynamicFilter
```
function getDynamicFilter()
```
  - getIconFilter : IconFilter
```
function getIconFilter()
```
  - getTop10Filter : Top10Filter
```
function getTop10Filter()
```
  - getFieldIndex/setFieldIndex : Number
```
function getFieldIndex() / function setFieldIndex(value)
```
    Gets and sets the column offset in the range.
- Method Detail
  - selectAll
```
function selectAll()
```