TdxSpreadSheetConditionalFormattingRuleTopBottomValuesValueType Enum

Enumerates available formatted cell number interpretation modes in a “Top/Bottom Values“ conditional formatting rule.

Declaration

TdxSpreadSheetConditionalFormattingRuleTopBottomValuesValueType = (
    tbvvtRank,
    tbvvtPercent
);

Members

Name
tbvvtRank
tbvvtPercent

Remarks

Options include:

Value	Description	Example (Value = 5)
tbvvtRank	The rule’s Value property specifies the absolute number of cells within the affected cell range(s). The specified value is clamped within the range between 1 and 1000, inclusive.
tbvvtPercent	The Value property specifies the relative cell number as a percentage of all cells within the affected cell range(s). The specified value is clamped within the range between 1 and 100, inclusive. The calculated number of formatted cells is always rounded down. For instance, only the two cells containing the highest or lowest values change their style if the rule applies custom formatting to 5% of all the 55 affected cells.

The “Top/Bottom Values“ conditional formatting rule’s ValueType property references the TdxSpreadSheetConditionalFormattingRuleTopBottomValuesValueType type.