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

TdxSpreadSheetConditionalFormatting Members

A conditional formatting controller of a Table View worksheet displayed by the Spreadsheet or Report Designer control.

#Constructors
Show Inherited Hide Inherited

Name Description
Create(IdxSpreadSheetConditionalFormattingOwner) Creates a new conditional formatting controller for the specified worksheet or conditional formatting provider for a data controller. Inherited from TdxSpreadSheetCustomConditionalFormatting.
Create(TdxSpreadSheetTableView) Creates a new conditional formatting controller for the specified Table View worksheet.

#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.
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(TdxSpreadSheetCustomConditionalFormattingRuleClass,Untyped) Creates a new rule with an empty list of affected cell ranges. Inherited from TdxSpreadSheetCustomConditionalFormatting.
Add(string,TdxSpreadSheetCustomConditionalFormattingRuleClass,Untyped) Creates a new rule and adds it to the conditional formatting controller.
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 recording a set of conditional formatting changes as a single history action in a Spreadsheet or Report Designer control.
BeginUpdate Postpones all redraw operations that reflect appearance changes in the parent control until an EndUpdate procedure call. Inherited from TdxSpreadSheetCustomConditionalFormatting.
Clear Deletes all conditional formatting rules applied to the parent control. Inherited from TdxSpreadSheetCustomConditionalFormatting.
EndEditing(Boolean) Finishes recording a set of conditional formatting changes as a single history action in a Spreadsheet or Report Designer control.
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.
GetHashCode Inherited from TObject.
ReferencesToString(TdxSpreadSheetAreaList) Converts the specified cell area list to a delimited string of references. Inherited from TdxSpreadSheetCustomConditionalFormatting.
Remove(TdxSpreadSheetCustomConditionalFormattingRule) Destroys the specified conditional formatting rule. Inherited from TdxSpreadSheetCustomConditionalFormatting.
ToString Inherited from TObject.
See Also