Construction options for createFormulaAdapter.

The FormulaAdapterOptions.resolve callback maps a parsed CellRef to its underlying graph node, returning undefined for cells that have not been registered. Returning undefined triggers an unresolved-ref error for direct cell references and silently skips the missing cell inside range aggregations, matching traditional spreadsheet semantics.

interface FormulaAdapterOptions {
    resolve: (ref: CellRef) => undefined | CellNode;
    sheet: string;
    workbook: string;
}

Properties

resolve: (ref: CellRef) => undefined | CellNode

Lookup hook from a parsed cell reference to a registered graph node.

Type declaration

    • (ref: CellRef): undefined | CellNode
    • Parameters

      • ref: CellRef

        Column/row reference parsed from the formula source.

      Returns undefined | CellNode

      The underlying CellNode, or undefined if no cell has been registered at that reference.

sheet: string

Identifier of the sheet the registered cells belong to.

workbook: string

Identifier of the workbook the registered cells belong to.