TdxSpreadSheetConditionalFormattingRuleCustomScaleStopValueType Enum
Enumerates threshold value intepretation modes.
#Declaration
TdxSpreadSheetConditionalFormattingRuleCustomScaleStopValueType = (
cssvtLimitValue,
cssvtValue,
cssvtPercent,
cssvtFormula,
cssvtPercentile
);
#Members
Name |
---|
cssvt
|
cssvt
|
cssvt
|
cssvt
|
cssvt
|
#Remarks
Options include:
Value | Description |
---|---|
cssvt | A threshold-based conditional formatting rule uses the topmost or lowermost numeric value within the affected cell range |
ccsvt | A conditional formatting rule uses its explicitly specified threshold value as is. In this mode, the rule evaluation threshold’s Value and Actual |
cssvt | A conditional formatting rule uses its explicitly specified threshold value as a percentage of the maximum value within the affected cell range 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. |
cssvt | A conditional formatting controller parses a string assigned to the cell evaluation threshold’s Value property as an Express Activating this mode automatically resets the rule evaluation threshold’s Value property to an empty string. |
cssvt | 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.