[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

iconSet (Icon Set)

Describes an icon set conditional formatting rule.

[Example: This example demonstrates the "3Arrows" style of icons. The first icon in the set shall be shown if the cell's value is less than the 33rd percentile. The second icon in the set shall be shown if the cell's value is less than the 67th percentile, and greater than or equal to the 33rd percentile. The third icon in the set shall be shown if the cell's value is greater than or equal to the 67th percentile.

<iconSet iconSet="3Arrows">
<
cfvo type="percentile" val="0"/>
<cfvo type="percentile" val="33"/>
<cfvo type="percentile" val="67"/>
</iconSet>

end example]

Parent Elements

cfRule3.3.1.9)

 

Child Elements

Subclause

cfvo (Conditional Format Value Object)

§3.3.1.10

 

Attributes

Description

iconSet (Icon Set)

The icon set to display.

 

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

percent (Percent)

Indicates whether the thresholds indicate percentile values, instead of number values.

 

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

reverse (Reverse Icons)

If '1', reverses the default order of the icons in this icon set.

 

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

showValue (Show Value)

Indicates whether to show the values of the cells on which this icon set is applied.

 

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

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

<complexType name="CT_IconSet">

   <sequence>

   <element name="cfvo" type="CT_Cfvo" minOccurs="2" maxOccurs="unbounded"/>

   </sequence>

   <attribute name="iconSet" type="ST_IconSetType" use="optional" default="3TrafficLights1"/>

   <attribute name="showValue" type="xsd:boolean" use="optional" default="true"/>

   <attribute name="percent" type="xsd:boolean" default="true"/>

   <attribute name="reverse" type="xsd:boolean" use="optional" default="false"/>

</complexType>