TFormula Class

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

Remarks

There are 4 public members here: 1) The formula text 2) The internal formula data. This member is not public. 3) The formula result. If RecalcMode is not manual, this value will be ignored. 4) The formula span. Some formulas, like some array formulas, can span over more than one cell. Not all of them need to be set, in fact, you won't probably never set internal formula data. Internal formula data is used so we can make Flexcel1.SetValue(FlexCel2.GetValue(1,1)); and not have to convert data->text->back to data.

Syntax

Namespace: FlexCel.Core

public class TFormula: ICloneable, IConvertible

Constructors

Name	Description
TFormula	Overloaded TFormula TFormula(String) TFormula(String, Object) TFormula(String, Object, TFormulaSpan)

Methods

Name	Description
Clone	Returns a Deep copy of the formula.
ToString	Returns the formula result as a string.
Equals	Returns true if obj is equal to this instance.
GetHashCode	Hashcode of the formula.

Properties

Name	Description
Text	The formula text, as it is written on Excel. It must begin with "=" or "{" for array formulas.
Result	The formula result.
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