[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

iconFilter (Icon Filter)

This element specifies the icon set and particular icon within that set to filter by. For any cells whose icon does not match the specified criteria, the corresponding rows shall be hidden from view when the filter is applied.

[Example:

<filterColumn colId="3">
<iconFilter iconSet="3Arrows" iconId="0"/>
</filterColumn>

end example]

Parent Elements

filterColumn3.3.2.7)

 

Attributes

Description

iconId (Icon Id)

Zero-based index of an icon in an icon set. The absence of this attribute means "no icon"

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

iconSet (Icon Set)

Specifies which icon set is used in the filter criteria.

 

The possible values for this attribute are defined by the ST_IconSetType simple type (§3.18.44).

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_IconFilter">

   <attribute name="iconSet" type="ST_IconSetType" use="required"/>

   <attribute name="iconId" type="xsd:unsignedInt" use="optional"/>

</complexType>