TFormula Record

An Excel formula. Use this class to pass a formula to an Excel sheet.

Syntax

TFormula = record;

Name	Description
Span	For multicell formulas (like an array formula entered over more than one cell) this property says how many rows and columns the formula uses. Normal formulas will span one single cell

Name	Description
Create	Overloaded Create Create(string) Create(string, TSingleFormulaValue) Create(string, TSingleFormulaValue, TFormulaSpan)
Null	Creates an undefined Excel formula
ToString	Returns the formula result as a string.
Equals	Returns true if obj is equal to this instance.
GetHashCode	Hashcode of the formula.
IsNull	Returns true if the record doesn't have a defined value.
HasValue	Returns true if the record has a defined value. This is the inverse of IsNull

Name	Description
Equality	Adapts the = operator so it returns true when both instances have the same values.
Inequality	Adapts the <> operator so it returns true when both instances have different values.

Name	Description
Text	The formula text, as it is written on Excel. It must begin with "=" or "{" for array formulas.
FormulaResult	The formula result.