Compartir a través de

2.7.9 ST_CfvoType

  • Artículo

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

Referenced by: CT_Cfvo

This simple type specifies how the Conditional Formatting Value Object (CFVO) value is determined. In the following table, X represents a parameter value. The value of X is determined by the value of the f element in the parent CT_Cfvo element. If the f element in the parent CT_Cfvo element is absent, then the value of X is 0. MUST be a value from the following table.

Value

Meaning

num

X

percent

The minimum value in the range of cells that the conditional formatting rule applies to plus X percent of the difference between the maximum and minimum values in the range of cells that the conditional formatting rule applies to.

For example, if the min and max values in the range are 1 and 10 respectively, and X is 10, then the CFVO value is 1.9.

max

The maximum value from the range of cells that the conditional formatting rule applies to.

min

The minimum value from the range of cells that the conditional formatting rule applies to.

formula

X, or if the f element is formed by the numerical-constant rule alone in the grammar provided in Formulas, the formula is ignored and X is 0.

percentile

The minimum value of the cell that is in the X percentile of the range of cells that the conditional formatting rule applies to.

autoMin

The smaller of zero or the minimum value from the range of cells that the conditional formatting rule applies to.

autoMax

The larger of zero or the maximum value from the range of cells that the conditional formatting rule applies to.

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

 <xsd:simpleType name="ST_CfvoType">
   <xsd:restriction base="xsd:string">
     <xsd:enumeration value="num"/>
     <xsd:enumeration value="percent"/>
     <xsd:enumeration value="max"/>
     <xsd:enumeration value="min"/>
     <xsd:enumeration value="formula"/>
     <xsd:enumeration value="percentile"/>
     <xsd:enumeration value="autoMin"/>
     <xsd:enumeration value="autoMax"/>
   </xsd:restriction>
 </xsd:simpleType>

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