Table of Contents

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

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