Package io.keikai.axyra.sheets.formula


package io.keikai.axyra.sheets.formula
User-defined formula functions and the built-in function catalog.

Implement UserFunction (numbers in, a number out) or TypedUserFunction (any cell value in and out), and register it with Workbook.registerFunction(java.lang.String, io.keikai.axyra.sheets.formula.UserFunction) or Workbook.registerTypedFunction(java.lang.String, io.keikai.axyra.sheets.formula.TypedUserFunction). A function must not call back into the workbook that is calculating it.

Functions lists the built-in functions the engine evaluates; it needs no workbook.

  • Class
    Description
    Queries the engine's catalog of built-in Excel-compatible functions.
    A user-defined formula function that receives typed values, including ranges.
    A numeric user-defined formula function.