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 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
Show Inherited Hide Inherited

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