TdxSpreadSheetConditionalFormattingRuleThreeColorScale Members
A “Three Color Scale“ 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 “Three Color Scale“ 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. |
| Index | Specifies the conditional formatting rule’s zero-based index in the conditional formatting controller. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| MaxValue | Specifies the “Three Color Scale“ conditional formatting rule’s maximum threshold value and the corresponding key gradient color. |
| MiddleValue | Specifies the “Three Color Scale“ conditional formatting rule’s middle threshold value and the corresponding key gradient color. |
| MinValue | Specifies the “Three Color Scale“ conditional formatting rule’s minimum threshold value and the corresponding key gradient color. |
| Owner | Returns the conditional formatting controller to which the rule belongs. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
| StopIfTrue protected | Specifies if the conditional formatting controller evaluates rules with lower priorities if applied to the same cell range(s).. Inherited from TdxSpreadSheetCustomConditionalFormattingRule. |
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 |
|---|---|
| DefaultMaxValueColor | Specifies the default gradient key color of the “Three Color Scale“ conditional formatting rule’s maximum threshold value. |
| DefaultMiddleValueColor | Specifies the default gradient key color of the “Three Color Scale“ conditional formatting rule’s intermediate threshold value. |
| DefaultMinValueColor | Specifies the default gradient key color of the “Three Color Scale“ conditional formatting rule’s minimum threshold value. |
See Also