TExportConditionalFormatting

Description

TExportConditionalFormatting stores the information about conditional formatting of a cell.

Properties

NameTypeDescription
Rules[Index: Integer]TExportConditionalFormattingRuleList of formatting rules (items with higher index have higher priority).

Functions & procedures

function AddRule(const aCondition: TExportCondition; const aLimit1AsFormula: OWideString;
  const aLimit2AsFormula: OWideString = ''): TExportConditionalFormattingRule; overload;
function AddRule(const aCondition: TExportCondition; const aLimit1AsNumber: Double; const aLimit2AsNumber: Double = 0): TExportConditionalFormattingRule; overload;
function AddRule(const aIndex: Integer; const aCondition: TExportCondition; const aLimit1AsFormula: OWideString; const aLimit2AsFormula: OWideString = ''): TExportConditionalFormattingRule; overload;
function AddRule(const aIndex: Integer; const aCondition: TExportCondition; const aLimit1AsNumber: Double; const aLimit2AsNumber: Double = 0): TExportConditionalFormattingRule; overload;
Adds a new formatting rule.
procedure DeleteRule(const aIndex: Integer);
Deletes a rule.
procedure MoveRule(const aCurIndex, aNewIndex: Integer);
Moves a rule from aCurIndex to aNewIndex.
procedure ExchangeRules(const aIndex1, aIndex2: Integer);
Exchange rules with indizes aIndex1 and aIndex2.
Categories