[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

border (Border)

Expresses a single set of cell border formats (left, right, top, bottom, diagonal). Color is optional. When missing, 'automatic' is implied.

Parent Elements

borders3.8.5); dxf3.8.14); ndxf3.11.1.4); odxf3.11.1.6)

 

Child Elements

Subclause

bottom (Bottom Border)

§3.8.6

diagonal (Diagonal)

§3.8.13

horizontal (Horizontal Inner Borders)

§3.8.24

left (Left Border)

§3.8.27

right (Right Border)

§3.8.35

top (Top Border)

§3.8.43

vertical (Vertical Inner Border)

§3.8.44

 

Attributes

Description

diagonalDown (Diagonal Down)

A boolean value indicating if the cell's diagonal border includes a diagonal line, starting at the top left corner of the cell and moving down to the bottom right corner of the cell.

 

[Example:

 

This example shows a thin diagonal down line:

 

 

end example]

 

 

 

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

diagonalUp (Diagonal Up)

A boolean value indicating if the cell's diagonal border includes a diagonal line, starting at the bottom left corner of the cell and moving up to the top right corner of the cell.

 

[Example:

 

This example shows a thin diagonal up line:

 

 

end example]

 

 

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

outline (Outline)

A boolean value indicating if left, right, top, and bottom borders should be applied only to outside borders of a cell range.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_Border">

   <sequence>

   <element name="left" type="CT_BorderPr" minOccurs="0" maxOccurs="1"/>

   <element name="right" type="CT_BorderPr" minOccurs="0" maxOccurs="1"/>

   <element name="top" type="CT_BorderPr" minOccurs="0" maxOccurs="1"/>

   <element name="bottom" type="CT_BorderPr" minOccurs="0" maxOccurs="1"/>

   <element name="diagonal" type="CT_BorderPr" minOccurs="0" maxOccurs="1"/>

   <element name="vertical" type="CT_BorderPr" minOccurs="0" maxOccurs="1"/>

   <element name="horizontal" type="CT_BorderPr" minOccurs="0" maxOccurs="1"/>

   </sequence>

   <attribute name="diagonalUp" type="xsd:boolean" use="optional"/>

   <attribute name="diagonalDown" type="xsd:boolean" use="optional"/>

   <attribute name="outline" type="xsd:boolean" use="optional" default="true"/>

</complexType>