TdxSpreadSheetConditionalFormattingAreaInfo Class
Stores information required to analyze numeric values within the cell ranges affected by a conditional formatting rule.
Declaration
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.