TExportCellBorders

Description

TExportCellBorders stores the information about all cell borders.

Properties

NameTypeDescription
LeftTExportCellBorderLeft border
TopTExportCellBorderTop border
RightTExportCellBorderRight border
BottomTExportCellBorderBottom border
DiagonalDownTExportCellBorder Diagonal border from top-left to bottom-right corner.
DiagonalUpTExportCellBorder Diagonal border from bottom-left to top-right corner.
Information: XLSX (Excel) supports only one style for DiagonalDown and DiagonalUp - if both diagonal borders are exported, the DiagonalDown style is applied on both diagonal borders.

Functions & procedures

function SetBorders(const aBorders: TCellBorders;
  const aStyle: TCellBorderStyle = ebThin;
  const aColor: TColor = clNone): TExportCellBorders;
Sets the style and color of borders defined in aBorders.
Borders that are not defined by aBorders are set to ebNone (i.e. hidden).
The function returns Self.
function SetBorder(const aBorder: TCellBorder;
  const aStyle: TCellBorderStyle = ebThin;
  const aColor: TColor = clNone): TExportCellBorders;
Sets the style and color of the corresponding border defined in aBorder.
aColor = clNone does not change the border color.
The function returns Self.
Categories