HyperFormula 3.4.0 makes the calculation engine a first-class citizen in AI-assisted development. This release ships an official skill for coding agents, a new guide and machine-readable documentation that let any AI assistant work with HyperFormula accurately, and five new customer-requested functions: XIRR, SORT, UNIQUE, VSTACK, and HSTACK.

An Official HyperFormula Skill for Your Coding Agent

If you build with an AI coding assistant, you’ve probably watched it confidently invent an API that doesn’t exist. Generic models know spreadsheets; they don’t always know HyperFormula’s actual configuration options, method signatures, or events.

The new official HyperFormula skill fixes that. Install it once from the plugin marketplace, and it loads automatically whenever your conversation touches HyperFormula — no manual prompting required. The skill acts as a quick setup wizard and reference: it walks the agent through scaffolding a project, choosing the right configuration, registering custom functions, and debugging formula issues using accurate, up-to-date knowledge of the engine.

The skill is open source and maintained in the handsontable-skills repository, and it can also be installed manually by copying it into your local skills directory.

New Guide: Set Up Your Coding Agent

The skill is one path; not everyone uses the same tools. The new Set up your coding agent guide covers every way to connect HyperFormula documentation to your AI workflow:

• Machine-readable docs — the full documentation is now published as llms-full.txt, and every docs page has a Markdown version (append .md to any docs URL). Paste a link or file into any agent and it gets clean, token-efficient content instead of scraped HTML.
• Zero-setup MCP servers — GitMCP and Context7 let agents fetch live HyperFormula docs on demand, with no installation or authentication.
• Agent-specific instructions — for Claude Code, Cursor, GitHub Copilot, and generic API-based agents.
• Whatever your setup, there’s now a supported way to make your assistant answer HyperFormula questions from the real documentation rather than from memory.

Five New Functions, Closing the Gap on Full Excel-Compatibility

We’ve added five new functions in this release, bringing us one step closer to parity with Excel and Google Sheets.

XIRR: Rate of Return for Real-World Cash Flows

The IRR function we shipped in 3.2.0 assumes evenly spaced payments. Real cash flows rarely cooperate — investments, loan repayments, and project budgets happen on irregular dates. XIRR was one of the most requested follow-ups from customers building financial applications, and it handles exactly that case:

=XIRR(B2:B10, C2:C10) // values, dates
=XIRR(B2:B10, C2:C10, 0.15) // with an optional initial guess

It returns the internal rate of return for a schedule of cash flows with arbitrary dates, matching Excel’s behavior.

SORT, UNIQUE, VSTACK, HSTACK: The Modern Dynamic Array Family Grows

Version 3.3.0 introduced SEQUENCE as the first of the modern dynamic array functions popularized by Excel 365 and Google Sheets. This release adds four more.

SORT gives you a stable, locale-aware ordering; UNIQUE preserves first-occurrence order and can optionally keep only values that appear exactly once; VSTACK and HSTACK pad ragged inputs the same way Excel does. They’re designed to compose.

Merging two lists, removing duplicates, and sorting the result — a task that used to require helper columns or application code — is now a single formula:

=SORT(UNIQUE(VSTACK(A1:A10, C1:C10)))

Other Improvements

• Modernized framework integration guides. The React, Angular, Vue, and Svelte guides and demos were rewritten around current best practices.
• Indonesian language pack. HyperFormula now speaks 18 languages — Bahasa Indonesia joins the list, thanks to a community contribution from Reckbeg.
• Currency formats in TEXT. A new stringifyCurrency configuration option lets you plug in a custom currency formatter.
• Lookup functions handle empty cells correctly. MATCH, VLOOKUP, HLOOKUP, and XLOOKUP no longer return wrong results or \#N/A when the search range contains empty cells.
• Parser stability fix. Entering a long digit string with a stray non-digit character near the end could freeze the page; the number parser now handles this input gracefully.

Release Notes

Added

• Added the getAvailableFunctions() and getFunctionDetails() methods (both static and instance) for retrieving function metadata.
• Added new functions: VSTACK, HSTACK.
• Added a new function: XIRR.
• Added the UNIQUE function.
• Added the SORT function.
• Added an Indonesian (Bahasa Indonesia) language pack.
• Added a stringifyCurrency config option that lets you plug in a custom currency formatter for the TEXT function.

Fixed

• Fixed the behavior of MATCH, VLOOKUP, HLOOKUP, and XLOOKUP functions when the search range contained empty cells.
• Fixed the VLOOKUP, HLOOKUP, and XLOOKUP functions to return 0 instead of an empty value when the matched cell in the result range is empty.
• Fixed the page freezing when entering a long string of digits containing a non-digit character near the end into a cell.

Get Started

Upgrade with:

npm install hyperformula@3.4.0

Then point your coding agent at the new Set up your coding agent guide and let it do the rest.