CalcEngine class

CalcEngine encapsulates the code required to parse and compute formulas.

Constructors

CalcEngine(Worksheet parentObject)
Create a new instance for CalcEngine.

Properties

excelLikeComputations bool
A property that gets or sets the calculations of the
getter/setter pair
formulaErrorStrings List<String>
The list of error strings which are used within the Essential Calculate internally. Users can make changes to this internal error strings. Default settings by assigning the new strings to the corresponding position.Reload_errorStrings should be invoked to reset or modify the internal error strings.
final
hashCode int
The hash code for this object.
no setterinherited
runtimeType Type
A representation of the runtime type of the object.
no setterinherited
useDatesInCalculations bool
Gets or sets whether dates can be used as operands in calculations. The default value is false.
getter/setter pair
useNoAmpersandQuotes bool
A property that gets/sets whether Strings concatenated using the '&' operator should be returned inside double quote marks.
getter/setter pair

Methods

noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
pullUpdatedValue(String cellRef) String
This method retrieves the value in the requested cell reference using fresh computations for any cells that affect the value of the requested cell.
registerGridAsSheet(String refName, Worksheet model, int sheetFamilyID) → void
register_gridAsSheet is a method that registers an Worksheet Object so it can be referenced in a formula from another Worksheet Object.
toString() String
A string representation of this object.
inherited

Operators

operator ==(Object other) bool
The equality operator.
inherited

Static Properties

modelToSheetID Map?
getter/setter pair
parseArgumentSeparator String
A static property that gets/sets character to be recognized by the parsing code as the delimiter for arguments in a named formula's argument list.
getter/setter pair
parseDateTimeSeparator String
A static property that gets/sets the character to be recognized by the parsing engine as datetime separator for date.
getter/setter pair
parseDecimalSeparator String
A static property that gets/sets the character to be recognized by the parsing engine as decimal separator for numbers.
getter/setter pair

Static Methods

createSheetFamilyID() int
createSheetFamilyID is a method to create familyID for a sheet.