Skip to main content
The formula engine is part of the workbook. When you change a cell, the formulas that depend on it are marked dirty. When you read one of them, it is calculated. Nothing is calculated that you do not read.

Check for errors

Read a formula’s value back after you write it. A formula that Microsoft Excel cannot calculate gives the same error here: #NAME? for an unknown function or name, #REF! for a reference to a deleted cell, #VALUE!, #DIV/0! and so on.

Calculation mode

application controls calculation as the Formulas tab in Microsoft Excel does.

Call a function

book.functions.call(name, args) calculates one worksheet function without a cell.

The core model

Workbook from @reductoai/xlsx is the model under the facade. It addresses cells by zero-based row and column and reads cached values directly. Use it for bulk reads.
The engine covers the worksheet functions of Microsoft Excel, including dynamic arrays (FILTER, SORT, UNIQUE, SEQUENCE), LET and LAMBDA. calc.functionNames() lists them. See the Overview for what it does not support.