TdxSpreadSheetCell.AsFormula Property

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

Declaration

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.