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

TcxDataControllerConditionalFormatting Members

A conditional formatting controller in Data Grid, Vertical Grid, and Tree List controls.

#Constructors
Show Inherited Hide Inherited

Name Description
Create(TcxDataControllerConditionalFormattingProvider) Creates a new TcxDataControllerConditionalFormatting class instance for the specified conditional formatting provider.
Create(IdxSpreadSheetConditionalFormattingOwner) Creates a new conditional formatting controller for the specified worksheet or conditional formatting provider for a data controller. Inherited from TdxSpreadSheetCustomConditionalFormatting.

#Properties
Show Inherited Hide Inherited

Name Description
CellStyles

Provides access to ExpressSpreadSheet-compatible styles applied to cells in a worksheet or Grid View

Provides access to ExpressSpreadSheet-compatible cell styles used in a worksheet or Grid View to which conditional formatting rules are applied.

Inherited from TdxSpreadSheetCustomConditionalFormatting.
DataController Provides access to the data controller whose fields serve as a data source for the conditional formatting controller.
ExcludeFilteredOutRecords Specifies whether the controller calculates cell formatting conditions only for those fields in the source data controller that meet the current filter criteria.
Owner Provides access to the source of cell data and layouts to which the conditional formatting rules are applied. Inherited from TdxSpreadSheetCustomConditionalFormatting.
RuleCount Returns the total number of conditional formatting rules applied to a worksheet or Grid View. Inherited from TdxSpreadSheetCustomConditionalFormatting.
Rules Provides zero-based indexed access to individual conditional formatting rules applied to a worksheet or Grid View. Inherited from TdxSpreadSheetCustomConditionalFormatting.

#Methods
Show Inherited Hide Inherited

Name Description
Add(TcxCustomDataField,TdxSpreadSheetCustomConditionalFormattingRuleClass,Untyped) Creates a new conditional formatting rule and applies it to the specified field in the source data controller.
Add(TdxSpreadSheetCustomConditionalFormattingRuleClass,Untyped) Creates a new rule with an empty list of affected cell ranges. Inherited from TdxSpreadSheetCustomConditionalFormatting.
Add(Integer,TdxSpreadSheetCustomConditionalFormattingRuleClass,Untyped) Creates a new conditional formatting rule and applies it to the required field by its index.
Add(string,TdxSpreadSheetCustomConditionalFormattingRuleClass,Untyped) Creates a new conditional formatting rule and applies it to the required field by its name.
Add(TRect,TdxSpreadSheetCustomConditionalFormattingRuleClass,Untyped) Creates a new rule and applies it to the specified cell range. Inherited from TdxSpreadSheetCustomConditionalFormatting.
Assign(TdxSpreadSheetCustomConditionalFormatting) Replaces the currently stored conditional formatting rules with rules obtained from another conditional formatting controller. Inherited from TdxSpreadSheetCustomConditionalFormatting.
BeginEditing Initiates editing a set of conditional formatting rules applied to a worksheet or Grid View. Inherited from TdxSpreadSheetCustomConditionalFormatting.
BeginUpdate Postpones all redraw operations that reflect appearance changes in the parent control until an EndUpdate procedure call. Inherited from TdxSpreadSheetCustomConditionalFormatting.
CanShowRulesManagerDialog Identifies if the “Conditional Formatting Rules Manager” dialog is available.
Clear Deletes all conditional formatting rules applied to the parent control. Inherited from TdxSpreadSheetCustomConditionalFormatting.
EndEditing(Boolean) Finishes editing a set of conditional formatting rules applied to a worksheet or Grid View. Inherited from TdxSpreadSheetCustomConditionalFormatting.
EndUpdate Applies all pending changes and redraws the parent control after a BeginUpdate procedure call. Inherited from TdxSpreadSheetCustomConditionalFormatting.
Equals(TObject) Inherited from TObject.
FlushCache Invalidates the calculated results of conditional expressions in all stored rules. Inherited from TdxSpreadSheetCustomConditionalFormatting.
GetFieldDisplayName(TcxCustomDataField) Returns the display name of a specific field in the source data controller.
GetHashCode Inherited from TObject.
GetItemDisplayName(Integer)
GetItemFieldName(Integer)
IsFieldVisible(TcxCustomDataField) Identifies if the specified field in the source data controller is visible in a data presentation control.
IsItemVisible(Integer)
ReferencesToString(TdxSpreadSheetAreaList) Converts the specified cell area to a delimited string of references to contiguous fields in the source data controller.
Remove(TdxSpreadSheetCustomConditionalFormattingRule) Destroys the specified conditional formatting rule. Inherited from TdxSpreadSheetCustomConditionalFormatting.
ShowRulesManagerDialog Displays the “Conditional Formatting Rules Manager” dialog.
ToString Inherited from TObject.
See Also