Function createFormulaAdapter

  • createFormulaAdapter(
        graph: Graph,
        options: FormulaAdapterOptions,
    ): FormulaAdapter

    Build a FormulaAdapter bound to a specific graph, workbook, and sheet.

    Parameters

    • graph: Graph

      The causl graph that will own the derived nodes.

    • options: FormulaAdapterOptions

      Workbook/sheet identifiers and the cell-ref resolver.

    Returns FormulaAdapter

    A FormulaAdapter ready to register parsed formulas.

    Example

    const adapter = createFormulaAdapter(graph, {
      workbook: 'wb1',
      sheet: 'Sheet1',
      resolve: (ref) => cellsByA1.get(cellRefToA1(ref)),
    })
    adapter.registerFormula({ col: 2, row: 0 }, parseFormula('=A1+B1'))

    See

Settings

Member Visibility