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.
FILTER, SORT, UNIQUE, SEQUENCE), LET and LAMBDA. calc.functionNames() lists them. See the Overview for what it does not support.