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

TdxSpreadSheetConditionalFormattingAreaInfo Class

Stores information required to analyze numeric values within the cell ranges affected by a conditional formatting rule.

#Declaration

Delphi
TdxSpreadSheetConditionalFormattingAreaInfo = class(
    TObject
)

#Remarks

This class provides the following members that allow you to:

  • Access the list of cell ranges analyzed by a conditional formatting rule (Areas);

  • Identify whether the specified value is the top, bottom, or unique within the analyzed cell ranges (IsBottomValue, IsTopValue, and IsUniqueValue);

  • Obtain the number of numeric values within the analyzed cell ranges (NumericValueCount);

  • Obtain the calculated minimum, maximum, and average values within the analyzed cell ranges (MinValue, MaxValue, and AverageValue);

  • Obtain the calculated standard deviation value for all numeric values within the analyzed cell ranges (StandardDeviation).

The TdxSpreadSheetConditionalFormattingCustomRule class’ AreaInfo property references a TdxSpreadSheetConditionalFormattingAreaInfo object.

#Inheritance

TObject
TdxSpreadSheetConditionalFormattingAreaInfo
See Also