[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ST_VerticalAlignment (Vertical Alignment Types)

This enumeration value indicates the type of vertical alignment for a cell, i.e., whether it is aligned top, bottom, vertically centered, justified or distributed.

This simple type's contents are a restriction of the XML Schema string datatype.

The following are possible enumeration values for this type:

Enumeration Value

Description

bottom (Aligned To Bottom)

The vertical alignment is aligned-to-bottom.

center (Centered Vertical Alignment)

The vertical alignment is centered across the height of the cell.

distributed (Distributed Vertical Alignment)

When text direction is horizontal: the vertical alignment of lines of text is distributed vertically, where each line of text inside the cell is evenly distributed across the height of the cell, with flush top and bottom margins.

 

When text direction is vertical: behaves exactly as distributed horizontal alignment. The first words in a line of text (appearing at the top of the cell) are flush with the top edge of the cell, and the last words of a line of text are flush with the bottom edge of the cell, and the line of text is distributed evenly from top to bottom.

 

[Example: Horizontal text: this first example shows four lines of text (read horizontally from left to right) distributed vertically across the height of the cell. The first line is "abc", the second line is "def", the third line is "ghi" and the fourth line is "jkl".

 

 

Vertical text: this second example shows three lines of text (read vertically from top to bottom) distributed vertically across the height of the cell. The lines of text are:

 

abcd efg hijklmnop qrs

tuv wx

yzabc defg hijk lmnop

 

The rendering looks like this:

 

 

end example]

 

justify (Justified Vertically)

When text direction is horizontal: the vertical alignment of lines of text is distributed vertically, where each line of text inside the cell is evenly distributed across the height of the cell, with flush top and bottom margins.

 

When text direction is vertical: similar behavior as horizontal justification. The alignment is justified (flush top and bottom in this case). For each line of text, each line of the wrapped text in a cell is aligned to the top and bottom (except the last line). If no single line of text wraps in the cell, then the text is not justified.

 

[Example: Horizontal text: this first example shows four lines of text (read horizontally from left to right) justified vertically across the height of the cell. The first line is "abc", the second line is "def", the third line is "ghi" and the fourth line is "jkl".

 

 

Vertical text: this second example shows three lines of text (read vertically from top to bottom) distributed vertically across the height of the cell. The lines of text are:

 

abcd efg hijklmnop qrs

tuv wx

yzabc defg hijk lmnop

 

The rendering looks like this:

 

end example]

 

top (Align Top)

The vertical alignment is aligned-to-top.

 

Referenced By

alignment@vertical3.8.1)

The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_VerticalAlignment">

   <restriction base="xsd:string">

   <enumeration value="top"/>

   <enumeration value="center"/>

   <enumeration value="bottom"/>

   <enumeration value="justify"/>

   <enumeration value="distributed"/>

   </restriction>

</simpleType>