<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

<borders> (§3.8.5); <dxf> (§3.8.14); <ndxf> (§3.11.1.4); <odxf> (§3.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:

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:

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>