Description
Hi all!
We’re excited to introduce HyperFormula 3.0, a major release with significant new features and improvements. This update includes the powerful new XLOOKUP
function, better ES module compatibility, and improved documentation.
New Feature: XLOOKUP
Function
The newly added XLOOKUP
function simplifies data searches by combining the capabilities of popular VLOOKUP
and HLOOKUP
into a single, intuitive function. It dynamically identifies matching values within a specified range and retrieves corresponding results from another range.
XLOOKUP
reduces the need for nested functions and manual adjustments, saving you time and effort - especially when working with complex spreadsheet logic.
ES Module Build Update
We’ve updated the ES module build to use .mjs files and modified the exports property in package.json. This change allows importing i18n files in Node.js environments and ensures better compatibility with modern setups.
Documentation Improvements
We’ve updated the documentation to make it clearer and more accessible. This includes fixing bugs, improving examples, and optimizing navigation for a better developer experience.