Formulas

Store formula sources, use references and local names, and handle scalar values and errors.

Combine values and references with spreadsheet operators, intersections, unions, and 3-D sheet spans.

Return rectangular formula results and reference their derived spill cells.

Choose reference targets at calculation time with OFFSET and INDIRECT.

Recalculate random values and runtime references on edits, or supply a fixed UTC clock instant.

Calculate circular references as Excel does: turn on iterative calculation, set the iteration limit and maximum change, and save it in XLSX files.

Find values, aggregate matching cells, and calculate cash flows with explicit shape and error rules.

Summarize, forecast, and clean data with the full formula engine. Worked examples for every function family in @sheetwrite/formulas.