Skip to main content

TdxSpreadSheetConditionalFormattingRuleTopBottomValues Members

A Top/Bottom Values 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 Top/Bottom Values 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.
Direction Specifies if the rule applies custom formatting to top or bottom values in target cell ranges.
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.
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.
Value Specifies the absolute or relative number of affected cells in target cell ranges.
ValueType Specifies if the rule applies custom formatting to an absolute or relative number of cells.

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.
See Also