TFormula.Create Method

Overloads

TFormula.Create

Creates an empty Excel formula

Syntax

Unit: FlexCel.Core

class function TFormula.Create: TFormula; static; overload;

See also

TFormula.Create(string)

Creates a formula with the corresponding text and result=null.

Syntax

Unit: FlexCel.Core

class function TFormula.Create(const aText: string): TFormula; static; overload;

Parameters

<-> Parameter Type Description
const aText string Formula Text

See also

TFormula.Create(string, TSingleFormulaValue)

Creates a formula with the corresponding text and result.

Syntax

Unit: FlexCel.Core

class function TFormula.Create(const aText: string; const aResult: TSingleFormulaValue): TFormula; static; overload;

Parameters

<-> Parameter Type Description
const aText string Formula Text
const aResult TSingleFormulaValue Formula Result

See also

TFormula.Create(string, TSingleFormulaValue, TFormulaSpan)

Creates a formula that spans to more than one row or column. Use it to create multicell array formulas or what-if tables.

Syntax

Unit: FlexCel.Core

class function TFormula.Create(const aText: string; const aResult: TSingleFormulaValue; const aSpan: TFormulaSpan): TFormula; static; overload;

Parameters

<-> Parameter Type Description
const aText string Formula Text
const aResult TSingleFormulaValue Formula Result. You will normally want to set this to null, as it will be recalculated by FlexCel.
const aSpan TFormulaSpan How many rows and columns this formula will span, and in which position for the array the formula is.

See also