Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetConditionalFormattingRuleTopBottomValuesValueType Enum

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

#Declaration

Delphi
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.

See Also