We’ve just released HyperFormula 3.0.1. This version brings a few anticipated bug fixes, updates the documentation, and improves the experience of using named expressions. Additionally, we’re sharing a preview of our short-term roadmap to keep you informed about what’s coming next.

Named Expressions: Improved Behavior and Easier Configuration

This release brings refinements to how named expressions behave and how they can be integrated into your setup. We’ve resolved an issue where named expressions added during engine initialization were not updated after changes, leading to some unpredictable results (#1501). Now, they stay in sync, so your dynamic formulas behave exactly as you’d expect. We’ve also addressed an issue where reusing the same named expression within a single formula could throw an Edge does not exist error (#1102). With both fixes in place, your formulas should now run more reliably than ever.

Additionally, we’ve improved the documentation to provide a clearer, more practical guide for defining named expressions during engine initialization. It shows how to pass named expressions as parameters when creating a HyperFormula instance using factory methods like buildEmpty, buildFromArray, or buildFromSheets. This approach allows you to define multiple expressions at once, improving both code readability and performance.

For example, instead of calling addNamedExpression() three times, you can now write:

const namedExpressions = [{
  name: 'AnnualInterestRate',
  expression: `=${sheetName}!$B$1`,
},{
  name: 'NumberOfMonths',
  expression: `=${sheetName}!$B$2`,
},{
  name: 'LoanAmount',
  expression: `=${sheetName}!$B$3`,
}];

HyperFormula.buildFromSheets({ [sheetName]: tableData }, config, namedExpressions);

Live demo

With better guidance in the docs, this method is now much easier to discover and adopt.

Community Spotlight

A huge thank you to the contributors who helped shape this release:

• @jbmolle
• @Esmail-Rahmani
• @ggorlen

Whether it’s improving functionality, or refining our documentation, your contributions make a real difference. HyperFormula gets better with every release thanks to your support, and we always appreciate your involvement in the project.

What’s Next on the Roadmap

We’re building HyperFormula with a clear plan that carries us through the end of the year, and we’d like to share what’s ahead. Our development will follow a steady, systematic approach, with regular releases every 6-9 weeks. This rhythm allows us to deliver meaningful improvements consistently, while making sure that each update is thoroughly tested and reliable.

In the coming months, we’ll be focusing on continuing work on stability and reliability, with particular attention to fixing issues affecting named expressions (#1498, #1194) and cross-sheet operations (#1477, #1116). We’ll also continue improving our documentation to make the library more accessible, refining the custom functions interface (#1401) for a better developer experience, and benchmarking HyperFormula’s performance (#911) against other leading spreadsheet applications.

Looking ahead to next year, we plan to expand our coverage of the OpenFormula standard (#274). We are currently missing 15 rarely used functions from the Small Group Evaluator standard, and our goal is to close that gap

Release Notes

Fixed

• Fixed Edge does not exist error when a named expression is used twice in the same formula. #1102
• Fixed typos in the built-in functions guide. #1517
• Fixed an issue where named expressions added on engine initialization were not updated on changes. #1501