[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
ST_CfvoType (Conditional Format Value Object Type)
This simple type expresses the type of the conditional formatting value object (cfvo). In general the cfvo specifies one value used in the gradated scale (max, min, midpoint, etc).
This simple type's contents are a restriction of the XML Schema string datatype.
The following are possible enumeration values for this type:
|
Enumeration Value |
Description |
|
formula (Formula) |
The minimum/ midpoint / maximum value for the gradient is determined by a formula. |
|
max (Maximum) |
Indicates that the maximum value in the range shall be used as the maximum value for the gradient. |
|
min (Minimum) |
Indicates that the minimum value in the range shall be used as the minimum value for the gradient. |
|
num (Number) |
Indicates that the minimum / midpoint / maximum value for the gradient is specified by a constant numeric value. |
|
percent (Percent) |
Value indicates a percentage between the minimum and maximum values in the range shall be used as the minimum / midpoint / maximum value for the gradient. |
|
percentile (Percentile) |
Value indicates a percentile ranking in the range shall be used as the minimum / midpoint / maximum value for the gradient. |
|
Referenced By |
|
cfvo@type (§3.3.1.10) |
The following XML Schema fragment defines the contents of this simple type:
<simpleType name="ST_CfvoType">
<restriction base="xsd:string">
<enumeration value="num"/>
<enumeration value="percent"/>
<enumeration value="max"/>
<enumeration value="min"/>
<enumeration value="formula"/>
<enumeration value="percentile"/>
</restriction>
</simpleType>