HyperFormula 3.3.0 is the largest function release in the project’s history — 20 new Excel-compatible functions in a single update.
The headline addition is the complete D* database function family: DSUM, DAVERAGE, DMAX, DMIN, DPRODUCT, DCOUNT, DCOUNTA, DGET, DSTDEV, DSTDEVP, DVAR, and DVARP. These let you filter and aggregate structured data using criteria ranges, all within a formula — no external query logic needed.
Also new in this release:
-
PERCENTILE and QUARTILE families, including .INC and .EXC variants for Excel-consistent boundary handling
-
TEXTJOIN — concatenate ranges with a delimiter, skip empty cells
-
SEQUENCE — generate arrays of sequential numbers; configurable rows, columns, start value, and step
-
Two memory leak fixes for long-running instances, plus a new maxPendingLazyTransformations config option for explicit memory control
-
AI integrations in development: Vercel AI SDK, LangChain, and an MCP server — letting agents offload formula evaluation to a deterministic engine instead of recomputing it on demand
Check out the full blog post: