TExportConditionalFormattingRule stores a rule in the conditional formatting list of a cell.
Name | Type | Description |
---|---|---|
Condition | TExportCondition | Type of condition:
|
Limit1AsFormula | OWideString | Limit1 as formula string. |
Limit2AsFormula | OWideString | Limit2 as formula string. |
Limit1AsNumber | Double | Limit1 as number. |
Limit2AsNumber | Double | Limit2 as number. |
Alignment | TCellHAlignment | Horizontal alignment |
VAlignment | TCellVAlignment | Vertical alignment |
FontColor | TColor | Font color |
FontStyle | TFontStyles | Font style |
BGColor | TColor | Background color |
function Set*(const *): TExportConditionalFormattingRule; |
---|
The Set* functions set the appropriate property and return Self (the formatting rule object).
Thanks to this, more Set* functions can be called in one line. Example: //var xCell: TExportCell; with xCell.ConditionalFormatting do begin AddRule(ecBetween, 5, 7).SetFontColor(clYellow).SetBGColor(clGreen). SetFontStyle([fsBold]); AddRule(ecGreaterThan, 10).SetFontColor(clWhite).SetBGColor(clBlack). SetFontStyle([fsBold, fsItalic]); end; |