BorderType complexType

Specifies the properties of a particular border within the Borders element.

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
Position PositionType required Specifies one of the six possible borders to use for cells.
  • Left
  • Top
  • Right
  • Bottom
  • DiagonalLeft
  • DiagonalRight
Color xsd:string optional Specifies the color of a border. See external namespace.
LineStyle Anonymous optional Specifies the style of a border.
  • None
  • Continuous
  • Dash
  • Dot
  • DashDot
  • DashDotDot
  • SlantDashDot
  • Double
Weight Anonymous optional Specifies the weight (or thickness) in points of a border.

maxInclusive = 3.5

Definition

      
<xsd:complexType name="BorderType" >
  <xsd:attribute form="qualified" name="Position" type="PositionType" use="required">
  </xsd:attribute>
  <xsd:attribute form="qualified" name="Color" type="xsd:string" use="optional" default="Automatic">
  </xsd:attribute>
  <xsd:attribute form="qualified" name="LineStyle" use="optional">
    <xsd:simpleType>
      <xsd:restriction base="xsd:string">
        <xsd:enumeration value="None" />
        <xsd:enumeration value="Continuous" />
        <xsd:enumeration value="Dash" />
        <xsd:enumeration value="Dot" />
        <xsd:enumeration value="DashDot" />
        <xsd:enumeration value="DashDotDot" />
        <xsd:enumeration value="SlantDashDot" />
        <xsd:enumeration value="Double" />
      </xsd:restriction>
    </xsd:simpleType>
  </xsd:attribute>
  <xsd:attribute form="qualified" name="Weight" use="optional" default="0">
    <xsd:simpleType>
      <xsd:restriction base="xsd:double">
        <xsd:maxInclusive value="3.5" />
      </xsd:restriction>
    </xsd:simpleType>
  </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