[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format Intellectual Property Rights Notice for Open Specifications Documentation

1456.1.1CT_IconSet

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

Referenced by: CT_CfRule

A complex type that specifies the properties of a conditional formatting rule that uses an icon set. The first cfvo element following this element MUST be ignored. There MUST be greater than or equal to three cfvo elements and MUST be less than or equal to five cfvo elements following this complex type.

Child Elements:

cfvo: A CT_Cfvo element that specifies a threshold value between each icon in the icon set.

cfIcon: A CT_CfIcon element that specifies a particular icon to use within an icon set. This element MUST be present if and only if custom equals "true".

Attributes:

iconSet: An ST_IconSetType attribute that specifies the icon set used.

showValue: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the cells in the applied range display the icon and cell value, or the icon only.

Value	Meaning
"true"	The icon and cell value are shown in the cell.
"false"	Only the icon is shown in the cell.

percent: Undefined and MUST be ignored.

reverse: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the icons in the icon set specified in iconSet are shown in reverse order. If custom equals "true" this value MUST be ignored.

Value	Meaning
"true"	The icons specified in iconSet are shown in reverse order.
"false"	The icons specified in iconSet are shown in the order defined by the icon set.

custom: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether a custom set of icons is used. If this value is "true", there MUST be the same number of cfIcon elements as cfvo elements and the icons specified by the cfIcon elements are used rather than those specified by iconSet. If this value is "false", there MUST be 0 cfIcon elements.

Value	Meaning
"false"	No custom set of icons is used.
"true"	A custom set of icons is used.

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

1457

1458

1459

1460

1461

1462

1463

1464

1465

1466

1467

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

1467.1.1CT_ColorScale

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

Referenced by: CT_CfRule

A complex type that specifies a color scale used in conditional formatting.

Child Elements:

cfvo: A CT_Cfvo element that specifies the cell values corresponding to the interpolation colors of the color scale. The CT_ColorScale MUST have either two or three child CT_Cfvo elements.

If there are two child CT_Cfvo elements present, the first child CT_Cfvo element specifies the cell value corresponding to the beginning color of the color scale. The second child CT_Cfvo element specifies the cell value corresponding to the end color of the color scale.

If there are three child CT_Cfvo elements present, the first child CT_Cfvo element specifies the cell value corresponding to the beginning color of the color scale. The second child CT_Cfvo element specifies the cell value corresponding to the midpoint color of the color scale. The third child CT_Cfvo element specifies the cell value corresponding to the end color of the color scale.

color: A CT_Color ([ISO/IEC29500-4:2012] section A.2) element that specifies the interpolation colors of the color scale for the cfvo element at the same corresponding position. The CT_ColorScale MUST have either two or three child CT_Color ([ISO/IEC29500-4:2012] section A.2) elements, and the number of child elements MUST equal the number of CT_Cfvo child elements.

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

1468

1469

1470

1471

1472

1473

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