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).