ColorFilter
Contents
[
Hide
]ColorFilter class
Represents filtering the range by color.
class ColorFilter;
Constructors
| Name | Description |
|---|---|
| constructor(VObject) | Constructs from a VObject convertible to this. |
Properties
| Property | Type | Description |
|---|---|---|
| filterByFillColor | boolean | Whether filter by the cell’s fill color. |
Methods
| Method | Description |
|---|---|
| getColor(WorksheetCollection) | Gets the color of this filter. |
| toVObject() | Gets the VObject. |
constructor(VObject)
Constructs from a VObject convertible to this.
constructor(vobj: VObject);
Parameters:
| Parameter | Type | Description |
|---|---|---|
| vobj | VObject | The vobject. |
filterByFillColor
Whether filter by the cell’s fill color.
filterByFillColor : boolean;
Remarks
True: cell’s fill color; False: cell’s font color.
getColor(WorksheetCollection)
Gets the color of this filter.
getColor(sheets: WorksheetCollection) : Color;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| sheets | WorksheetCollection |
Returns
toVObject()
Gets the VObject.
toVObject() : VObject;