Skip to main content

TdxSpreadSheetConditionalFormattingRuleIconSetStop Class

A threshold value used as a criterion for applying a specific icon to data cells affected by the Icon Set conditional formatting rule.

Declaration

TdxSpreadSheetConditionalFormattingRuleIconSetStop = class(
    TdxSpreadSheetConditionalFormattingRuleCustomScaleStop
)

Remarks

This class has public API members that allow you to do the following:

  • Specify the numeric threshold value and how an “Icon Set” rule interprets it (Value and ValueType).

  • Obtain the calculated threshold value used for evaluating all cells affected by the rule (ActualValue).

  • Select an icon and specify the condition under which it is displayed by an affected data cell (IconIndex and ComparisonOperator).

  • Identify the threshold value’s position within the rule’s Stops collection (Index).

  • Optimize the application performance when applying multiple changes to the threshold value and its concomitant settings (BeginUpdate and EndUpdate).

Direct TdxSpreadSheetConditionalFormattingRuleIconSetStop Class Reference

An Icon Set conditional formatting rule’s Stops property references a TdxSpreadSheetConditionalFormattingRuleIconSetStop object.

Inheritance

See Also