Create(TdxSpreadSheetCustomConditionalFormatting) Constructor

Creates a new “Above or Below Average“ rule in the specified conditional formatting controller.

Declaration

constructor Create(AOwner: TdxSpreadSheetCustomConditionalFormatting); override;

Parameters

Name	Type	Description
AOwner	TdxSpreadSheetCustomConditionalFormatting	A conditional formatting controller.

Remarks

Call this constructor to create an “Above or Below Average” rule with the default settings within a conditional formatting controller passed as the AOwner parameter. Alternatively, you can call either of the controller’s overloaded Add procedures passing a reference to the TdxSpreadSheetConditionalFormattingRuleAboveOrBelowAverage class as the ARuleClass parameter.

The Create constructor initializes the StandardDeviationLevel property to the MinStandardDeviationLevel constant value and calls the inherited constructor to create the Style property set for storing cell formatting settings and an empty list of the cell ranges affected by the rule.

To delete an “Above or Below Average” conditional formatting rule, pass it as the ARule parameter of the conditional formatting controller’s Remove procedure.