TdxSpreadSheetConditionalFormattingRuleCustomScaleStop Class
The base class for all classes that implement threshold values for cell range evaluation.
Declaration
TdxSpreadSheetConditionalFormattingRuleCustomScaleStop = class(
TInterfacedPersistent,
IcxStoredObject
)Remarks
This class is the direct ancestor of the TdxSpreadSheetConditionalFormattingRuleColorScaleStop and TdxSpreadSheetConditionalFormattingRuleIconSetStop classes that expand the core threshold value functionality with settings specific to the color gradient-based and icon set-based conditional formatting rules, respectively.
Main API Members
The TdxSpreadSheetConditionalFormattingRuleCustomScaleStop class has public API members that allow you to do the following:
Specify the numeric threshold value and how a conditional formatting rule interprets it (Value and ValueType).
Obtain the calculated threshold value used for evaluating the cells affected by a threshold-based conditional formatting rule (ActualValue).
Identify the threshold value’s position within the corresponding collection of a conditional formatting rule (Index).
Optimize the application performance when applying multiple changes to the threshold value and its concomitant settings (BeginUpdate and EndUpdate).
Direct TdxSpreadSheetConditionalFormattingRuleCustomScaleStop Class References
The Data Bar conditional formatting rule’s MinValue and MaxValue properties reference a TdxSpreadSheetConditionalFormattingRuleCustomScaleStop object.