Namespace IFormulaContext

Remarks

Formula functions are pure — they cannot reach the workbook, the sheet they sit on, or the clock. FormulaContext is the one channel that gives them sheet data, cell coordinates, date and number parsing, and evaluation hints without giving up that purity.

Import it and call its methods directly; there is nothing to construct or thread through arguments. Every call is already scoped to the cell being evaluated:

import { FormulaContext } from '@sheetxl/primitives';

export function ROWNUMBER(): number {
  return FormulaContext.getRow() + 1;
}
Copy

Capabilities

Implementors

The calculation engine provides the implementation. Third-party code (UDF packages, test harnesses) may supply its own for isolated evaluation or unit testing.