TUnsupportedFormula Class

An unsupported formula, the cell it is in, and the reason why it is not supported.

Syntax

Unit: FlexCel.Core

TUnsupportedFormula = class(TFlexCelObject);

Constructors

Name	Description
Create	Overloaded Create Create(TUnsupportedFormulaErrorType, TCellAddress, string, string) Create(TUnsupportedFormulaErrorType, TCellAddress, string, string, TCellAddressWithFileNameArray)

Methods

Name	Description
GetHashCode	Hashcode for this object.
Equals	Returns true if both objects have the same values.

Properties

Name	Description
ErrorType	Type of error.
Cell	Cell where the formula is (1 based)
FunctionName	If the error is TUnsupported​Formula​Error​Type.​Missing​Function then this is the name of the missing function. If the error is TUnsupported​Formula​Error​Type.​External​Reference then this is the name of the file not found.
FileName	This property has the name of the physical file being evaluated, and can be of use when evaluating linked files. If the files are opened from a stream or not from a physical place, it will be null.
StackTrace	This property only has a value is the error is TUnsupported​Formula​Error​Type.​Circular​Reference. It contains a list of all the cells that lead to this cell having to recalculate itself. Note that this stack is limited to the last TExcelFile.​Cell​Stack​Trace​MaxSize elements to avoid consuming too much memory.