API reference / Common / Engine types / GridBorder

Interface: GridBorder

A cell's borders — styleSheet/borders/border (CT_Border, §18.8.4), and the one a differential format carries, styleSheet/dxfs/dxf/border. The paths below are given under styleSheet/borders/border.

The leading and trailing edges are read into left and right: Excel writes left and right for them (MS-OI29500 §2.1.715, §2.1.702), where the Strict schema names them start and end.

Properties

Property	Description
left? GridBorderProperties	styleSheet/borders/border/left, or styleSheet/borders/border/start.
right? GridBorderProperties	styleSheet/borders/border/right, or styleSheet/borders/border/end.
top? GridBorderProperties	styleSheet/borders/border/top (§18.8.43).
bottom? GridBorderProperties	styleSheet/borders/border/bottom (§18.8.6).
diagonal? GridBorderProperties	styleSheet/borders/border/diagonal (§18.8.13) — the line both diagonals take.
vertical? GridBorderProperties	styleSheet/dxfs/dxf/border/vertical (§18.8.44) — the inner vertical edges of a range, "used in the context of dxf elements only".
horizontal? GridBorderProperties	styleSheet/dxfs/dxf/border/horizontal (§18.8.25) — the inner horizontal edges of a range, in a differential format only.
diagonalUp boolean	styleSheet/borders/border/@diagonalUp — the diagonal runs from the bottom-left corner to the top-right. false when absent, Office's default (MS-OI29500 §2.1.695).
diagonalDown boolean	styleSheet/borders/border/@diagonalDown — the diagonal runs from the top-left corner to the bottom-right. false when absent (MS-OI29500 §2.1.695).
outline boolean	styleSheet/borders/border/@outline — the left, right, top and bottom edges apply only to a range's outside. true when absent, the schema's default.