Skip to main content

TdxSpreadSheetConditionalFormattingRuleCellIs Members

A Cell Is 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 style-based conditional formatting rule in the specified conditional formatting controller. Inherited from TdxSpreadSheetConditionalFormattingRuleStyleBased.
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.
ComparisonOperator Specifies the Cell Is conditional formatting rule’s cell value comparison mode.
Expression Specifies a formula expression required to calculate a cell formatting criterion for Expression and Cell Is rules. Inherited from TdxSpreadSheetConditionalFormattingRuleExpression.
Expression2 Specifies a value or formula expression used as an additional cell formatting criterion for a Cell Is conditional formatting rule. Inherited from TdxSpreadSheetConditionalFormattingRuleExpression.
Formulas protected Provides indexed access to parsed and calculated expressions of the conditional formatting rule. Inherited from TdxSpreadSheetConditionalFormattingRuleExpression.
Index Specifies the conditional formatting rule’s zero-based index in the conditional formatting controller. Inherited from TdxSpreadSheetCustomConditionalFormattingRule.
Owner Returns the conditional formatting controller to which the rule belongs. Inherited from TdxSpreadSheetCustomConditionalFormattingRule.
StopIfTrue Specifies if the conditional formatting controller evaluates rules with lower priorities if applied to the same cell range(s).. Inherited from TdxSpreadSheetCustomConditionalFormattingRule.
Style Provides access to style settings applied to all cells that meet the rule’s formatting criteria. Inherited from TdxSpreadSheetConditionalFormattingRuleStyleBased.

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