<iconSet> (Icon Set)

Describes an icon set conditional formatting rule.

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

Parent Elements

<cfRule> (§3.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>