2.3.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/IEC29500-1:2012]

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

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. If set to true, the text is vertical text.

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

ReadingOrder: The reading order of the worksheet cell.

ShrinkToFit: Specifies whether to shrink to fit. If set to true, the font size is shrunk so that the contents fit the worksheet cell. Equivalent to the shrinkToFit attribute (2) of the CT_CellAlignment element specified in [ISO/IEC29500-1:2012].

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/IEC29500-1:2012].

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