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