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