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 | Specifies a single cell or cell range affected by the conditional formatting rule. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| AreaInfo protected | Inherited from TdxSpreadSheetConditionalFormattingCustomRule. |
| Areas | Specifies one or more cell ranges affected by the conditional formatting rule. 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 zero-based index in the conditional formatting controller. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| Owner | Returns the conditional formatting controller to which the rule belongs. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| StandardDeviationLevel | Specifies the standard deviation multiplier for the “Above or Below Average” conditional formatting rule. |
| StopIfTrue | Specifies if the conditional formatting controller evaluates rules with lower priorities if applied to the same cell range(s).. 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 | Disables repainting of the worksheet or Grid View until the EndUpdate procedure is called. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| Clone | Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| Clone(TdxSpreadSheetAreaList) | Creates a copy of the conditional formatting rule. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| Clone(TRect) | Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| EndUpdate | Enables repainting of the worksheet or Grid View after calling the BeginUpdate procedure. 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