HyperFormula 2.0.0: Reversed ranges and expanded whitespace character support
HyperFormula 2.0.0 is here! This version adds support for reversed ranges, lets you expand the scope of whitespace characters allowed, drops the GPU.js dependency, and improves the behavior of the RATE function.
From the formula authoring perspective, reversed ranges are the most important feature of this release.
So far, you could reference a range of cells in only one, ascending direction, for example:
- =A:B (entire columns)
- =1:2 (entire rows)
- =Sheet1!A1:Sheet5!B2 (across different sheets, so-called 3D reference. It’s fun!)
Starting with HyperFormula 2.0.0, you can reference ranges in any direction. The table below shows a few examples of reversed ranges allowed:
|Allowed before||Allowed now|
This feature complies with the OpenFormula standard.
Expanded whitespace character support
HyperFormula 2.0.0 lets you easily expand the scope of whitespace characters allowed within formulas.
By default, HyperFormula is compliant with the OpenFormula standard in this respect. This means that the only whitespace characters allowed are the following:
- SPACE (U+0020)
- CHARACTER TABULATION (U+0009)
- LINE FEED (U+000A)
- CARRIAGE RETURN (U+000D)
For example, with
ignoreWhiteSpace set to
'any', you can use non-breaking spaces within your formulas, without getting an error.
Dropping the GPU.js dependency
When releasing HyperFormula 1.2.0 back in September 2021, we removed GPU.js from optional dependencies, and marked the
gpuMode configuration options as deprecated (to learn more, see the HyperFormula 1.2.0 release blog).
With HyperFormula 2.0.0, it’s time to remove the GPU.js dependency and its options entirely. While having a negligible impact on HyperFormula’s performance (and only in some rare use cases), this decision significantly shortens the installation time.
Using GPU.js was a successful experiment to speed up the calculation time of some functions (MMULT, MAXPOOL, MEDIANPOOL, and TRANSPOSE) used with very large data sets. For all users who need the GPU acceleration in their projects, it’s still available in HyperFormula 1.0.0.
RATE function fix and documentation updates
HyperFormula 2.0.0 improves the behavior of the RATE function, by adjusting its approximation level and the maximum number of iterations.
Release notes: what we added
- Added support for reversed ranges. #834
- Added a new configuration option,
ignoreWhiteSpace, which allows for parsing formulas that contain whitespace characters of any kind. #898
Release notes: what we changed
- Breaking change: Removed the
gpu.jsdependency and its use, to speed up the installation time. #812
- Breaking change: Removed the deprecated
gpuModeconfiguration options. #812
Release notes: what we fixed
- Fixed an issue where the RATE function didn’t converge for some inputs. #905
The HyperFormula project was co-financed from European Union funds under the European Regional Development Funds as a part of the Smart Growth Operational Programme. Project implemented as a part of the National Centre for Research and Development: Fast Track.