What’s new in HyperFormula 1.3.0
Good news! Today, we’re releasing HyperFormula 1.3.0: an incremental update that brings two useful changes and fixes a few bugs along the way.
Easily access HyperFormula’s default configuration
HyperFormula comes with a long list of tweakable configuration options. They help you customize your HyperFormula usage—e.g. by enabling the array arithmetic mode, setting date formats, or setting calculations’ precision level.
Sometimes, though, you need to find out what the default configuration is. To make this easier for you, we added a new static property to the HyperFormula class:
defaultConfig property holds all of HyperFormula’s default configuration options.
getFillRangeData() with two different sheets
getFillRangeData() method lets you take a range of cells, and use it to fill another range of cells, while properly extending the range (using a wrap-around heuristic).
Starting from HyperFormula 1.3.0, the
getFillRangeData() method doesn’t bind you to a single sheet anymore. You can use two different sheets: one sheet for your source range of cells, and another sheet for your target range of cells.
Release notes: what we added
- Added a new static property:
getFillRangeData()method can now use one sheet for its source and another sheet for its target. #836
Release notes: what we fixed
- Fixed the handling of Unicode characters and non-letter characters in the PROPER function. #811
- Fixed unnecessary warnings caused by deprecated configuration options. #830
- Fixed the SUMPRODUCT function. #810