Share via

2.6.57 CT_IconFilter

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: iconFilter

This complex type specifies the icon set and particular icon within that set to filter by. Rows with a cell icon that do not match these criteria will be hidden when the filter is applied.

Attributes:

iconSet: An ST_IconSetType attribute that specifies the icon set used as the filter criteria.

iconId: An unsignedInt ([XMLSCHEMA2/2] section 3.3.22) attribute that specifies the index of the icon to be used as filter criteria. If iconSet is "NoIcons", this value MUST be 0 and this record does not specify a filter and MUST be ignored. If iconSet is not "NoIcons", this value MUST be greater than or equal to 0. If the icon set specified by iconSet has three icons, this value MUST be less than or equal to 2. If the icon set specified by iconSet has four icons, this value MUST be less than or equal to 3. If the icon set specified by iconSet has five icons, this value MUST be less than or equal to 4.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_IconFilter">
   <xsd:attribute name="iconSet" type="ST_IconSetType" use="required"/>
   <xsd:attribute name="iconId" type="xsd:unsignedInt" use="required"/>
 </xsd:complexType>

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).