2.4.14 ST_KpiSet
Referenced by: CT_Cell
The set of key performance indicator (KPI) to use for conditional formatting in a worksheet cell.
The following table shows the values for this type.
|
Value |
Meaning |
|---|---|
|
-1 |
|
|
0 |
Equivalent to the [MS-XLSX] ST_IconSetType 3Arrows enumeration value. |
|
1 |
Equivalent to the [MS-XLSX] ST_IconSetType 3ArrowsGray enumeration value. |
|
2 |
Equivalent to the [MS-XLSX] ST_IconSetType 3Flags enumeration value. |
|
3 |
Equivalent to the [MS-XLSX] ST_IconSetType 3TrafficLights1 enumeration value. |
|
4 |
Equivalent to the [MS-XLSX] ST_IconSetType 3TrafficLights2 enumeration value. |
|
5 |
Equivalent to the [MS-XLSX] ST_IconSetType 3Signs enumeration value. |
|
6 |
Equivalent to the [MS-XLSX] ST_IconSetType 3Symbols enumeration value. |
|
7 |
Equivalent to the [MS-XLSX] ST_IconSetType 3Symbols2 enumeration value. |
|
8 |
Equivalent to the [MS-XLSX] ST_IconSetType 4Arrows enumeration value. |
|
9 |
Equivalent to the [MS-XLSX] ST_IconSetType 4ArrowsGray enumeration value. |
|
10 |
Equivalent to the [MS-XLSX] ST_IconSetType 4RedToBlack enumeration value. |
|
11 |
Equivalent to the [MS-XLSX] ST_IconSetType 4Rating enumeration value. |
|
12 |
Equivalent to the [MS-XLSX] ST_IconSetType 4TrafficLights enumeration value. |
|
13 |
Equivalent to the [MS-XLSX] ST_IconSetType 5Arrows enumeration value. |
|
14 |
Equivalent to the [MS-XLSX] ST_IconSetType 5ArrowsGray enumeration value. |
|
15 |
Equivalent to the [MS-XLSX] ST_IconSetType 5Ratings enumeration value. |
|
16 |
Equivalent to the [MS-XLSX] ST_IconSetType 5Quarters enumeration value. |
|
17 |
Equivalent to the [MS-XLSX] ST_IconSetType 3Stars enumeration value. |
|
18 |
Equivalent to the [MS-XLSX] ST_IconSetType 3Triangles enumeration value. |
|
19 |
Equivalent to the [MS-XLSX] ST_IconSetType 5Boxes enumeration value. |
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this simple type.
-
<xs:simpleType name="ST_KpiSet"> <xs:restriction base="xs:short"> <xs:enumeration value="-1"/> <xs:enumeration value="0"/> <xs:enumeration value="1"/> <xs:enumeration value="2"/> <xs:enumeration value="3"/> <xs:enumeration value="4"/> <xs:enumeration value="5"/> <xs:enumeration value="6"/> <xs:enumeration value="7"/> <xs:enumeration value="8"/> <xs:enumeration value="9"/> <xs:enumeration value="10"/> <xs:enumeration value="11"/> <xs:enumeration value="12"/> <xs:enumeration value="13"/> <xs:enumeration value="14"/> <xs:enumeration value="15"/> <xs:enumeration value="16"/> <xs:enumeration value="17"/> <xs:enumeration value="18"/> <xs:enumeration value="19"/> </xs:restriction> </xs:simpleType>
See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).