2.3.13 CT_Style
Referenced by: CT_Styles
Cell formatting or border formatting.
Child Elements:
Font: The font specification for one or more worksheet cells or worksheet headers.
Alignment: The alignment and flow of text and conditional formatting within a worksheet cell. This element MUST be present when one or more attributes do not equal their respective default XSD values and MUST NOT be present otherwise.
Interior: The fill color or pattern mask and pattern color. This element MUST be present when a solid or pattern fill is present and MUST NOT be present otherwise.
gradient: The gradient fill style and color. This element MUST be present when a gradient fill is present and MUST NOT be present otherwise.
Borders: An unordered collection of CT_Border elements (section 2.3.11).
Attributes:
ID: A ST_cellStyleID (section 2.4.25) MUST be present when a cellStyle group (4) is present. A ST_borderStyleID (section 2.4.26) MUST be present when a borderStyle group (4) is present.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
-
<xs:complexType name="CT_Style"> <xs:sequence> <xs:element name="Font" minOccurs="0" maxOccurs="1" type="CT_Font"/> <xs:element name="Alignment" minOccurs="0" maxOccurs="1" type="CT_Alignment"/> <xs:choice minOccurs="0" maxOccurs="1"> <xs:element name="Interior" type="CT_Interior"/> <xs:element name="gradient" type="CT_gradient"/> </xs:choice> <xs:element name="Borders" minOccurs="0" maxOccurs="1" type="CT_Borders"/> </xs:sequence> <xs:attribute name="ID" use="required" type="ST_ID"/> </xs:complexType>
See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).