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.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. |