TExportCellStyle

Description

TExportCellStyle stores style information for cells, rows, columns and worksheets.

Properties

NameTypeDescription
AlignmentTCellHAlignmentHorizontal alignment
IndentByteCell indentation. Possible only with left or right alignment. Value range: 0..15.
VAlignmentTCellVAlignmentVertical alignment
FontTExportFontFont
Font_ReadOnlyTExportFontFont (only for read-only use!)
BGColorTColorBackground color
BordersTExportCellBordersBorder
Borders_ReadOnlyTExportCellBordersBorder (only for read-only use!)
OrientationTExportFlowOrientationText orientation:
  • efoLeftToRight: left-to-right (normal)
  • efoTopToBottom: top-to-bottom (every character will be on a new line)
RotationTExportCellRotationText rotation in degrees. Value range: -90..90.
Applicable only when Orientation is efoLeftToRight.
ProtectionTExportCellProtectionCell protection. Changing this property makes sense only when worksheet protection is enabled.
ecpLocked - cell is locked (protected).
ecpFormulaHidden - formula is hidden.
WrapTextBooleanWord wrap

Functions & procedures

function Set*(const *): TExportCellStyle;
The Set* functions set the appropriate style property and return Self (the style object). Thanks to this, more Set* functions can be called in one line.
Example:
//var xCell: TExportCell;
xCell.Style.SetFontName('Arial').SetFontSize(15).SetFontColor(clRed);
procedure Clear;
Clear the style.
All properties are set to auto (undefined) or default values.
Categories