[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
colorFilter (Color Filter Criteria)
This element specifies the color to filter by and whether to use the cell's fill or font color in the filter criteria. If the cell's font or fill color does not match the color specified in the criteria, the rows corresponding to those cells are hidden from view.
[Example:
<filterColumn colId="1">
<colorFilter dxfId="0" cellColor="0"/>
</filterColumn>
end example]
|
Parent Elements |
|
filterColumn (§3.3.2.7) |
|
Attributes |
Description |
|
cellColor (Filter By Cell Color) |
Flag indicating whether or not to filter by the cell's fill color. '1' indicates to filter by cell fill. '0' indicates to filter by the cell's font color.
For rich text in cells, if the color specified appears in the cell at all, it shall be included in the filter.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
dxfId (Differential Format Record Id) |
Id of differential format record (dxf) in the Styles Part which expresses the color value to filter by.
The possible values for this attribute are defined by the ST_DxfId simple type (§3.18.26). |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_ColorFilter">
<attribute name="dxfId" type="ST_DxfId" use="optional"/>
<attribute name="cellColor" type="xsd:boolean" use="optional" default="true"/>
</complexType>