FormulaApi class Formulas

The formula subsystem of a workbook: register custom functions that Sheet.evaluate can call.

excel.formula.registerFunction('TRIPLE', (args) {
  final v = args.isEmpty ? null : args.first;
  final n = v is IntCellValue ? v.value : 0;
  return IntCellValue(n * 3);
});

Properties

hashCode → int
The hash code for this object.
no setterinherited
registeredFunctions → Iterable<String>
The (upper-cased) names of all registered custom functions.
no setter
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited

Methods

noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
registerFunction(String name, ExcelFunction fn) → void
Registers a custom fn under name (case-insensitive) for formulas in this workbook. Re-registering a name replaces it. A custom function never shadows a built-in of the same name.
toString() → String
A string representation of this object.
inherited
unregisterFunction(String name) → bool
Removes the custom function name. Returns true if one was removed.

Operators

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