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 |