2.2.7 CT_Alignment

  • Article

Referenced by: CT_Style

The alignment and flow of text and conditional formatting within a worksheet cell.

Attributes:

Horizontal: Horizontal alignment of text. Equivalent to the horizontal attribute (2) of the CT_CellAlignment element specified in [ISO/IEC-29500-1]

WrapText: Specifies whether text wraps at whitespace. Equivalent to the wrapText attribute (2) of the CT_CellAlignment element specified in [ISO/IEC-29500-1].

Rotate: Angle of rotation in degrees, where the first character in the worksheet cell is the center of rotation.

§ A positive number indicates that the text is rotated counter-clockwise from the 0 position.

§ 0 indicates the text is not rotated.

§ A negative number indicates that the text is rotated by the absolute value of the number clockwise from the 0 position.

VerticalText: Specifies whether the text is vertical text.

Vertical: Vertical alignment of text. Equivalent to the vertical attribute (2) of the CT_CellAlignment element specified in [ISO/IEC-29500-1].

ReadingOrder: The reading order of the worksheet cell.

ShrinkToFit: Specifies whether to shrink to fit. Equivalent to the shrinkToFit attribute (2) of the CT_CellAlignment element specified in [ISO/IEC-29500-1].

Indent: A scaling factor used in conjunction with the DefaultIndentSize attribute (2) on the CT_Table element to create a margin in points. Equivalent to the indent attribute (2) of the CT_CellAlignment element specified in [ISO/IEC-29500-1].

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

 <xs:complexType name="CT_Alignment">
   <xs:attribute name="Horizontal" type="ST_enmHorizontalAlignment" default="Automatic" use="optional"/>
   <xs:attribute name="WrapText" type="xs:boolean" default="false" use="optional"/>
   <xs:attribute name="Rotate" default="0" use="optional" type="ST_Rotate"/>
   <xs:attribute name="VerticalText" type="xs:boolean" default="false" use="optional"/>
   <xs:attribute name="Vertical" type="ST_enmVerticalAlignment" default="Bottom" use="optional"/>
   <xs:attribute name="ReadingOrder" type="ST_enmReadOrder" default="Context" use="optional"/>
   <xs:attribute name="ShrinkToFit" type="xs:boolean" default="false" use="optional"/>
   <xs:attribute name="Indent" type="xs:unsignedInt" default="0" use="optional"/>
 </xs:complexType>

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