Skip to main content

TdxSpreadSheetConditionalFormattingExpression Members

Stores a parsed formula expression used by conditional formatting rules.

Constructors

Name Description
Create(TdxSpreadSheetCustomConditionalFormatting) Appends a new formula expression to the specified cell data provider‘s formula controller.

Properties

Name Description
ActualErrorCode Inherited from TdxSpreadSheetCustomFormula.
ActualValue Returns the formula expression’s calculation result. Inherited from TdxSpreadSheetCustomFormula.
Anchor Returns the coordinates of the formula expression’s anchor cell. Inherited from TdxSpreadSheetCustomFormula.
AnchorColumn Returns a zero-based index of the column to which the formula expression belongs. Inherited from TdxSpreadSheetCustomFormula.
AnchorRow Returns the zero-based index of the row to which the formula expression belongs. Inherited from TdxSpreadSheetCustomFormula.
ArrayFormulaArea Returns the area occupied by the array formula result. Inherited from TdxSpreadSheetCustomFormula.
ArrayFormulaSize Returns the dimensions (in cells) of an area occupied the array formula result. Inherited from TdxSpreadSheetCustomFormula.
AsText Returns the parsed formula expression as a text string. Inherited from TdxSpreadSheetCustomFormula.
Controller Provides access to the formula controller that handles the parsed formula expression. Inherited from TdxSpreadSheetCustomFormula.
ErrorCode Returns an error code indicating the parsed formula expression’s evaluation or calculation state. Inherited from TdxSpreadSheetCustomFormula.
ErrorIndex Returns the index of the first unrecognized character in the formula expression’s source text. Inherited from TdxSpreadSheetCustomFormula.
FormatSettings Provides access to the formula expression’s source text string parsing format settings. Inherited from TdxSpreadSheetCustomFormula.
IsArrayFormula Specifies if the formula expression’s calculation result is an array. Inherited from TdxSpreadSheetCustomFormula.
Iteration Inherited from TdxSpreadSheetCustomFormula.
ResultValue Provides access to the properties and methods related to parsing the formula expression’s source text. Inherited from TdxSpreadSheetCustomFormula.
SourceText Specifies the source text string of the parsed formula expression. Inherited from TdxSpreadSheetCustomFormula.
Tokens Provides access to the token tree of the parsed formula expression. Inherited from TdxSpreadSheetCustomFormula.
Value Returns the formula expression’s calculation result. Inherited from TdxSpreadSheetCustomFormula.
View Provides access to the worksheet or Grid View to which the formula expression belongs. Inherited from TdxSpreadSheetCustomFormula.

Methods

Name Description
EnumReferences(TdxSpreadSheetFormulaEnumReferencesProc,Boolean) Inherited from TdxSpreadSheetCustomFormula.
EnumReferences(TdxSpreadSheetFormulaEnumReferenceTokensProc,Boolean) Enumerates references in the formula expression. Inherited from TdxSpreadSheetCustomFormula.
Equals(TObject) Inherited from TObject.
GetHashCode Inherited from TObject.
ToString Inherited from TObject.
Validate Checks if the parsed formula expression is correct. Inherited from TdxSpreadSheetCustomFormula.
See Also