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:

language: 'enUS',

We’re also adding a new guide that details HyperFormula’s internationalization features and provides a full en-US configuration example.

Improved functions

To improve HyperFormula’s compliance with the OpenDocument standard, we’re fixing three functions:

• VLOOKUP
• HLOOKUP
• MATCH

Now, they behave exactly as specified in the standard.

Expanded documentation

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 VLOOKUP and HLOOKUP to handle duplicates in the way specified by the OpenDocument standard. (#1072)
• Fixed the MATCH function to handle descending ranges in the way specified by the OpenDocument standard. (#1063)

Acknowledgments

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.