HyperFormula 3.1.0 is now available #1562
Description
Hi,
HyperFormula 3.1.0 brings several updates aimed at improving the developer experience, formula behavior, and aligning more closely with spreadsheet standards. While this is a technical release, it introduces meaningful changes in naming consistency, formula logic, and documentation.
OFFSET Now Supports Cross-Sheet References
The OFFSET function now correctly handles references to other sheets, fixing an issue where sheet names were previously ignored. This brings HyperFormula’s behavior in line with mainstream engines like Excel and Google Sheets and improves reliability in multi-sheet formulas.
Smarter Naming for Custom Functions
If you’re using custom functions that work with arrays, take note: we’ve renamed two properties in the FunctionMetadata interface to make their purpose clearer:
• arrayFunction → enableArrayArithmeticForArguments
• arraySizeMethod → sizeOfResultArrayMethod
The original names are still supported for backward compatibility, but they are now officially deprecated and will be removed in a future major release.
Improved Documentation
This release also includes several updates to the documentation to make key concepts clearer and support easier onboarding for developers.