Share via

2.7.10 ST_IconSetType

  • Article

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

Referenced by: CT_RichSortCondition, CT_SortCondition, CT_IconFilter, CT_IconSet, CT_CfIcon

A simple type that specifies an icon set.

Value

Meaning

3Arrows

3 arrows. Green pointing up, yellow pointing right, red pointing down

3ArrowsGray

3 gray arrows. One pointing up, one pointing right, one pointing down

3Flags

3 colored flags. One green, one yellow, one red

3TrafficLights1

3 round traffic lights. One green, one yellow, one red.

3TrafficLights2

3 round traffic lights with black rectangle borders. One green, one yellow, one red.

3Signs

3 colored signs. One green circle, one yellow triangle, one red diamond

3Symbols

3 colored symbols. One green circle with check mark in center, one yellow circle with exclamation point in center, one red circle with X in center

3Symbols2

3 colored symbols. One green check mark, one yellow exclamation point, one red X

4Arrows

4 colored arrows. Green arrow pointing up. Yellow arrow pointing upwards at 45 degree angle. One yellow arrow pointing downwards at 45 degree angle. One red arrow pointing down.

4ArrowsGray

4 gray arrows. Arrow pointing up. Arrow pointing upwards at 45 degree angle. Arrow pointing downwards at 45 degree angle. Arrow pointing down.

4RedToBlack

Four circles red to black. Bright red circle. faded red circle. Faded gray circle. Black circle

4Rating

4 sets of 4 vertical bars. Each bar in set is taller than the previous, angling upwards from left to right. First set has first bar filled in, and the rest are grey. Second set has first 2 bars filled in, and the rest are grey. Third set has first 3 bars filled in, and the last is gray. Fourth set has all 4 bars filled in.

4TrafficLights

4 round traffic lights. One green, one yellow, one red, one black

5Arrows

5 colored arrows. One green arrow pointing up. One yellow arrow pointing upwards at 45 degree angle. One yellow arrow pointing right. One yellow arrow pointing downwards at 45 degree angle. One red arrow pointing down.

5ArrowsGray

5 gray arrows. One arrow pointing up. One arrow pointing upwards at 45 degree angle. One arrow pointing right. One arrow pointing downwards at 45 degree angle. One arrow pointing down.

5Rating

5 sets of 5 vertical bars for rating. Each bar in the set is taller than the previous, angling upwards from left to right. First set has all 5 bars filled in. Second set has first 4 bars filled in, and the the last is grey. Third set has first 2 bars filled in, and the rest are gray. Fourth set has zero bars filled in.

5Quarters

5 circles divided into quarters. First circle has all 4 quarters filled in black. Second circle has 3 quarters filled in black. Third circle has 2 quarters filled in black. Fourth circle has 1 quarter filled in black. Fifth circle has zero quarters filled in black.

3Stars

3 stars for rating. First star is completely filled in yellow. Second star is half yellow and half gray. Third star is all gray

3Triangles

Three colored triangles. Green triangle pointing up. Yellow triangle pointing away so only bottom can be seen. Red triangle pointing down

5Boxes

5 boxes split into four squares each. First box has all 4 squares filled in. Second box has 3 squares filled in. Third box has two squares filled in. Fourth box has one square filled in. Fifth box has zero squares filled in.

NoIcons

No icon set

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

 <xsd:simpleType name="ST_IconSetType">
   <xsd:restriction base="xsd:string">
     <xsd:enumeration value="3Arrows"/>
     <xsd:enumeration value="3ArrowsGray"/>
     <xsd:enumeration value="3Flags"/>
     <xsd:enumeration value="3TrafficLights1"/>
     <xsd:enumeration value="3TrafficLights2"/>
     <xsd:enumeration value="3Signs"/>
     <xsd:enumeration value="3Symbols"/>
     <xsd:enumeration value="3Symbols2"/>
     <xsd:enumeration value="4Arrows"/>
     <xsd:enumeration value="4ArrowsGray"/>
     <xsd:enumeration value="4RedToBlack"/>
     <xsd:enumeration value="4Rating"/>
     <xsd:enumeration value="4TrafficLights"/>
     <xsd:enumeration value="5Arrows"/>
     <xsd:enumeration value="5ArrowsGray"/>
     <xsd:enumeration value="5Rating"/>
     <xsd:enumeration value="5Quarters"/>
     <xsd:enumeration value="3Stars"/>
     <xsd:enumeration value="3Triangles"/>
     <xsd:enumeration value="5Boxes"/>
     <xsd:enumeration value="NoIcons"/>
   </xsd:restriction>
 </xsd:simpleType>

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