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

TdxSpreadSheetCell.AsFormula Property

Provides access to the parsed formula expression associated with the cell object.

#Declaration

Delphi
property AsFormula: TdxSpreadSheetFormula read; write;

#Property Value

Type
TdxSpreadSheetFormula

#Remarks

Use this property to access properties and methods of a formula expression within the cell object. For instance, you can copy formulas between cells by calling the AsFormula.Clone function or obtain the source text of a parsed formula expression by using the AsFormula.AsText property. Refer to the TdxSpreadSheetFormula and TdxSpreadSheetCustomFormula class descriptions for detailed information on all available options.

The AsFormula property value is nil if no formula expression is associated with the cell object. To identify if it has a formula, use the IsFormula or DataType property.

The AsFormula property is accessible via the IdxSpreadSheetCellData interface to provide uniform access to formula expressions in ExpressSpreadSheet and ExpressQuantumGrid Views.

Note

The SetText procedure provides a common technique to assign a formula expression to the cell object.

See Also