TdxSpreadSheetConditionalFormattingRuleAboveOrBelowAverage Members
An Above or Below Average conditional formatting rule.Constructors
| Name | Description |
|---|---|
| Create(TdxSpreadSheetCustomConditionalFormatting,TRect) | Creates a new conditional formatting rule in the specified conditional formatting controller. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| Create(TdxSpreadSheetCustomConditionalFormatting) | Creates a new Above or Below Average rule in the specified conditional formatting controller. |
| Create(TPersistent) | Initializes a new instance of the TcxInterfacedPersistent class with specified settings. Inherited from TcxInterfacedPersistent. |
Properties
| Name | Description |
|---|---|
| Area | Deprecated. This property exists for backward compatibility only. Use the Areas property instead. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| AreaInfo protected | Inherited from TdxSpreadSheetConditionalFormattingCustomRule. |
| Areas | Specifies target cell ranges. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| ComparisonOperator | Specifies the cell value comparison operator for calculating the “Above or Below Average” rule’s formatting condition. |
| Index | Specifies the conditional formatting rule’s index in the parent conditional formatting controller. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| Owner | Provides access to the parent conditional formatting controller. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| StandardDeviationLevel | Specifies the standard deviation multiplier for the “Above or Below Average” conditional formatting rule. |
| StopIfTrue | Specifies if the parent conditional formatting controller evaluates other rules with lower priority that are applied to the same areas if the current rule’s condition is met. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| Style | Provides access to style settings applied to all cells that meet the rule’s formatting criteria. Inherited from TdxSpreadSheetConditionalFormattingRuleStyleBased. |
Methods
| Name | Description |
|---|---|
| Assign(TPersistent) | Inherited from TPersistent. |
| AssignTo(TPersistent) | Inherited from TPersistent. |
| BeginUpdate | Postpones all redraw operations that reflect appearance changes in the parent control until an EndUpdate procedure call. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| Clone | Creates a copy of the conditional formatting rule and applies the created rule to the same areas. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| Clone(TdxSpreadSheetAreaList) | Creates a copy of the conditional formatting rule and applies the created rule to all target areas. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| Clone(TRect) | Creates a copy of the conditional formatting rule and applies the created rule to the specified cell range. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| EndUpdate | Applies all pending changes and redraws the parent control after a BeginUpdate procedure call. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| Equals(TObject) | Inherited from TObject. |
| GetDetails protected | Returns the conditional formatting rule’s name for the “Conditional Formatting Rules Manager” dialog. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| GetHashCode | Inherited from TObject. |
| GetNamePath | Inherited from TPersistent. |
| GetOwner | Inherited from TPersistent. |
| LoadFromStream(TcxReader) | Loads the conditional formatting rule’s settings from a stream via the specified stream reader. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| QueryInterface(TGUID,Untyped) | Inherited from TInterfacedPersistent. |
| SaveToStream(TcxWriter) | Saves the conditional formatting rule’s settings to a stream via the specified stream writer. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| ToString | Inherited from TObject. |
Constants
| Name | Description |
|---|---|
| MaxStandardDeviationLevel | Specifies the maximum standard deviation multiplier. |
| MinStandardDeviationLevel | Specifies the default standard deviation multiplier. |
See Also