Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetConditionalFormattingRuleTopBottomValues Members

A Top/Bottom Values conditional formatting rule.

#Constructors
Show Inherited Hide Inherited

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
Show Inherited Hide Inherited

Name Description
Area Deprecated. Specifies the target cell range. 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
Show Inherited Hide Inherited

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