TdxSpreadSheetConditionalFormattingRuleCustomScaleStopValueType Enum

Enumerates threshold value intepretation modes.

Declaration

TdxSpreadSheetConditionalFormattingRuleCustomScaleStopValueType = (
    cssvtLimitValue,
    cssvtValue,
    cssvtPercent,
    cssvtFormula,
    cssvtPercentile
);

Members

Name
cssvtLimitValue
cssvtValue
cssvtPercent
cssvtFormula
cssvtPercentile

Remarks

Options include:

Value	Description
cssvtLimitValue	A threshold-based conditional formatting rule uses the topmost or lowermost numeric value within the affected cell range(s) as the maximum or minimum cell evaluation threshold, respectively. Activating this mode automatically resets the rule evaluation threshold‘s Value property to the Null Variant value.
ccsvtValue	A conditional formatting rule uses its explicitly specified threshold value as is. In this mode, the rule evaluation threshold’s Value and ActualValue property values match. Activating this mode automatically resets the Value property to 0.
cssvtPercent	A conditional formatting rule uses its explicitly specified threshold value as a percentage of the maximum value within the affected cell range(s). Activating this mode automatically resets the Value property to a percentage calculated from the evaluation threshold’s index and the total number of thresholds in a conditional formatting rule.
cssvtFormula	A conditional formatting controller parses a string assigned to the cell evaluation threshold’s Value property as an ExpressSpreadSheet-compatible formula expression and uses its result as the actual threshold value. You can use any built-in or custom function registered in the functions repository. Activating this mode automatically resets the rule evaluation threshold’s Value property to an empty string.
cssvtPercentile	A conditional formatting rule interprets the specified evaluation threshold as a percentile value. Activating this mode automatically resets the Value property to a percentile value calculated from the evaluation threshold’s index and the total number of thresholds in a conditional formatting rule.

The conditional formatting rule threshold‘s ValueType property references the TdxSpreadSheetConditionalFormattingRuleCustomScaleStopValueType type.