HyperFormula 2.2.0: American English locale and better compliance with the OpenDocument standard
We’ve just released HyperFormula 2.2.0. This version adds the
enUS language alias, improves the behavior of a few functions, and expands the documentation about importing files and HyperFormula’s internationalization features.
Easier en-US configuration
To make it easier for you to match the locale expectations of your US users, we’re adding a new language pack:
enUS. It contains the same translations of function names and errors as the existing
enGB language pack, but you don’t have to think if
enGB matches your expectations anymore – you can just set:
We’re also adding a new guide that details HyperFormula’s internationalization features and provides a full en-US configuration example.
To improve HyperFormula’s compliance with the OpenDocument standard, we’re fixing three functions:
Now, they behave exactly as specified in the standard.
Apart from adding the new internationalization guide, we prepared a new page on importing XLSX and CSV files, with an example of integrating HyperFormula with ExcelJS. We hope it helps, and we’re planning to add more examples in the future.
Release notes: what we added
- Added an American English (
enUS) language pack. It’s a convenience alias: it contains the same translations as the existing British English (
enGB) language pack. (#1025)
Release notes: what we fixed
- Fixed functions
HLOOKUPto handle duplicates in the way specified by the OpenDocument standard. (#1072)
- Fixed the
MATCHfunction to handle descending ranges in the way specified by the OpenDocument standard. (#1063)
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.