TFormula.Create Method

Overloads

• TFormula.Create
• TFormula.Create(string)
• TFormula.Create(string, TSingleFormulaValue)
• TFormula.Create(string, TSingleFormulaValue, TFormulaSpan)

TFormula.Create

Creates an empty Excel formula

Syntax

Unit: FlexCel.Core

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

See also

• TFormula

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

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

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

• TFormula