Skip to main content

TdxSpreadSheetConditionalFormattingAreaInfo Members

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

Constructors

Name Description
Create(IdxSpreadSheetConditionalFormattingOwner,TdxSpreadSheetAreaList) Initializes a new instance of the TdxSpreadSheetConditionalFormattingAreaInfo class with specified settings.

Properties

Name Description
Areas Provides access to the list of cell ranges affected by a conditional formatting rule.
AverageValue Returns the calculated average of all numeric values within the list of affected cell ranges.
MaxValue Returns the highest numeric value within the list of affected cell ranges.
MinValue Returns the lowest numeric value within the list of affected cell ranges.
NumericValueCount Returns the total count of numeric cell values within the list of affected cell ranges.
StandardDeviation Returns the standard deviation calculated for all numeric cell values within the list of affected cell ranges.

Methods

Name Description
Equals(TObject) Inherited from TObject.
GetHashCode Inherited from TObject.
GetLimitValueForPercent(Integer)
GetLimitValueForPercentile(Integer)
IsBottomValue(Double,Integer) Identifies whether the specified value is at a specific lowest position by value among all cells within the list of affected areas.
IsTopValue(Double,Integer) Identifies whether the specified value is at a specific highest position by value among all cells within the list of affected areas.
IsUniqueValue(Variant) Identifies whether the specified value is unique within the list of affected cell ranges.
ToString Inherited from TObject.
See Also