[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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:
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>