AlignmentType complexType

Defines a collection of font alignment attributes.

Type Information

Namespace urn:schemas-microsoft-com:office:spreadsheet
Schema name XML Spreadsheet 2002

Elements and Attributes

Child Elements

None.

Attributes

Attribute Type Required Description Possible Values
Horizontal Anonymous optional Specifies the left-to-right alignment of text within a cell.
  • CenterAcrossSelection
  • Fill
  • Left
  • Right
  • Justify
  • Distributed
  • Center
  • Automatic
  • JustifyDistributed
ReadingOrder Anonymous optional Specifies the default right-to-left text entry mode for a cell.
  • RightToLeft
  • LeftToRight
  • Context
Indent xsd:unsignedLong optional Specifies the number of indents. This attribute is not supported by the Spreadsheet component. See external namespace.
Rotate Anonymous optional Specifies the rotation of text within a cell.

minInclusive = -90

maxInclusive = 90

ShrinkToFit TrueFalseType optional Specifies whether text size should be shrunk so that all of the text fits within a cell.
  • 0
  • 1
Vertical Anonymous optional Specifies the top-to-bottom alignment of text within a cell.
  • Automatic
  • Top
  • Bottom
  • Center
  • Justify
  • Distributed
  • JustifyDistributed
VerticalText TrueFalseType optional Specifies whether text characters are positioned to read vertically.
  • 0
  • 1
WrapText TrueFalseType optional Specifies whether the text in a cell should wrap at the cell boundary.
  • 0
  • 1

Definition

      
<xsd:complexType name="AlignmentType" >
  <xsd:attribute form="qualified" name="Horizontal" use="optional" default="Automatic">
    <xsd:simpleType>
      <xsd:restriction base="xsd:string">
        <xsd:enumeration value="CenterAcrossSelection" />
        <xsd:enumeration value="Fill" />
        <xsd:enumeration value="Left" />
        <xsd:enumeration value="Right" />
        <xsd:enumeration value="Justify" />
        <xsd:enumeration value="Distributed" />
        <xsd:enumeration value="Center" />
        <xsd:enumeration value="Automatic" />
        <xsd:enumeration value="JustifyDistributed" />
      </xsd:restriction>
    </xsd:simpleType>
  </xsd:attribute>
  <xsd:attribute form="qualified" name="ReadingOrder" use="optional" default="Context">
    <xsd:simpleType>
      <xsd:restriction base="xsd:string">
        <xsd:enumeration value="RightToLeft" />
        <xsd:enumeration value="LeftToRight" />
        <xsd:enumeration value="Context" />
      </xsd:restriction>
    </xsd:simpleType>
  </xsd:attribute>
  <xsd:attribute form="qualified" name="Indent" type="xsd:unsignedLong" use="optional" default="0">
  </xsd:attribute>
  <xsd:attribute form="qualified" name="Rotate" use="optional" default="0">
    <xsd:simpleType>
      <xsd:restriction base="xsd:double">
        <xsd:minInclusive value="-90" />
        <xsd:maxInclusive value="90" />
      </xsd:restriction>
    </xsd:simpleType>
  </xsd:attribute>
  <xsd:attribute form="qualified" name="ShrinkToFit" type="TrueFalseType" use="optional">
  </xsd:attribute>
  <xsd:attribute form="qualified" name="Vertical" use="optional" default="Automatic">
    <xsd:simpleType>
      <xsd:restriction base="xsd:string">
        <xsd:enumeration value="Automatic" />
        <xsd:enumeration value="Top" />
        <xsd:enumeration value="Bottom" />
        <xsd:enumeration value="Center" />
        <xsd:enumeration value="Justify" />
        <xsd:enumeration value="Distributed" />
        <xsd:enumeration value="JustifyDistributed" />
      </xsd:restriction>
    </xsd:simpleType>
  </xsd:attribute>
  <xsd:attribute form="qualified" name="VerticalText" type="TrueFalseType" use="optional" default="0">
  </xsd:attribute>
  <xsd:attribute form="qualified" name="WrapText" type="TrueFalseType" use="optional" default="0">
  </xsd:attribute>
</xsd:complexType>


    
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp