hyperformula - npm Package Versions

[2.1.0] - 2022-09-08

Added

• Added two new functions: MAXIFS and MINIFS. #1049

Changed

• Changed the rounding strategy of the default time-parsing function to be independent of the timeFormats configuration option. Now, time values are always rounded to the nearest millisecond (0.001 s). #953

Fixed

• Fixed a rounding issue that caused the TEXT function to incorrectly convert dates and times to strings. #1043
• Fixed an issue where functions SUMIF, SUMIFS, COUNTIF, COUNTIFS, and AVERAGEIF incorrectly handled complex numeric values. #951

Removed

• Removed all polyfills from the CommonJS build and the ES modules build. In the UMD build, kept only the polyfills required by the supported browsers. #1011

[2.0.1] - 2022-06-14

Changed

• Changed the following npm scripts (used internally): docs, docs:api, docs:dev, docs:build, coverage, typings:check. #977

Fixed

• Fixed an issue where it was impossible to add a custom function with no parameters. #968

[2.0.0] - 2022-04-14

For more information on this release, see:

• Release notes
• Blog post
• Migration guide

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

Changed

• Breaking change: Removed the gpu.js dependency and its use, to speed up the installation time. #812
• Breaking change: Removed the deprecated gpujs and gpuMode configuration options. #812

Fixed

• Fixed an issue where the RATE function didn't converge for some inputs. #905

[1.3.1] - 2022-01-11

Fixed

• Fixed an issue where warnings about deprecated configuration options were getting duplicated. #882

[1.3.0] - 2021-10-20

Added

• Added a new static property: defaultConfig. #822
• The getFillRangeData() method can now use one sheet for its source and another sheet for its target. #836

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

[1.2.0] - 2021-09-23

Changed

• Removed gpu.js from optional dependencies and marked config options gpujs and gpuMode as deprecated.

[1.1.0] - 2021-08-12

Added

• Added support for the array arithmetic mode in the calculateFormula() method. #782
• Added a new CellType returned by getCellType: CellType.ARRAYFORMULA. It's assigned to the top-left corner of an array, and is recognized by the isCellPartOfArray() and doesCellHaveFormula() methods. #781

Changed

• Deprecated the binarySearchThreshold configuration option, as every search of sorted data always uses binary search. #791

Fixed

• Fixed an issue with searching sorted data. #787
• Fixed the destroy method to properly destroy HyperFormula instances. #788

[1.0.0] - 2021-07-15

Added

• Added support for array arithmetic. #628
• Added performance improvements for array handling. #629
• Added ARRAYFORMULA function. #630
• Added FILTER function. #668
• Added ARRAY_CONSTRAIN function. #661
• Added casting to scalars from non-range arrays. #663
• Added support for range interpolation. #665
• Added parsing of arrays in formulas (together with respective config options for separators). #671
• Added support for vectorization of scalar functions. #673
• Added support for time in JS Date() objects on the input. #648
• Added validation of API argument types for simple types. #654
• Added named expression handling to engine factories. #680
• Added getAllNamedExpressionsSerialized method. #680
• Added parsing of arrays in formulas (together with respective config options for separators). #671
• Added utility function for filling ranges with source from other range. #678
• Added pretty print for detailedCellError. #712
• Added simpleCellRangeFromString and simpleCellRangeToString helpers. #720
• Added CellError to exports. #736
• Added mapping policies to the exports: AlwaysDense, AlwaysSparse, DenseSparseChooseBasedOnThreshold. #747
• Added #SPILL! error type. #708
• Added large tests for CRUD interactions. #755
• Added support for array arithmetic in plugins. #766
• Added a flag to getFillRangeData to support different types of offsetting. #767

Changed

• Breaking change: Changed API of many sheet-related methods to take sheetId instead of sheetName as an argument. #645
• Breaking change: Removed support for matrix formulas ({=FORMULA}) notation. Engine now supports formulas returning array of values (instead of only scalars). #652
• Breaking change: Removed numeric matrix detection along with matrixDetection and matrixDetectionThreshold config options. #669
• Breaking change: Changed API of the following methods to take SimpleCellRange type argument: copy, cut, getCellDependents, getCellPrecedents, getFillRangeData, getRangeFormulas, getRangeSerialized, getRangeValues, isItPossibleToMoveCells, isItPossibleToSetCellContents, moveCells. #687
• Breaking change: Changed the AGPLv3 license to GPLv3.
• Breaking change: Removed the free non-commercial license.
• Breaking change: Changed behaviour of setCellContents so that it is possible to override space occupied by spilled array. #708
• Breaking change: Changed behaviour of addRows/removeRows so that it is possible to add/remove rows across spilled array without changing array size. #708
• Breaking change: Changed behaviour of addColumns/removeColumns so that it is possible to add/remove columns across spilled array without changing array size. #732
• Breaking change: Changed config options #747:

| before | after | |-----------------------|----------------------| | matrixColumnSeparator | arrayColumnSeparator | | matrixRowSeparator | arrayRowSeparator |

• Breaking change: Changed CellType.MATRIX to CellType.ARRAY #747
• Breaking change: Changed API methods #747:

| before | after | |--------------------|-------------------| | matrixMapping | arrrayMapping | | isCellPartOfMatrix | isCellPartOfArray |

• Breaking change: Changed Exceptions #747:

| before | after | |------------------------------|-----------------------------| | SourceLocationHasMatrixError | SourceLocationHasArrayError | | TargetLocationHasMatrixError | TargetLocationHasArrayError |

• Changed SWITCH function, so it takes array as its first argument.
• Changed TRANSPOSE function, so it works with data of any type. #708
• Changed the way how we include gpu.js making it even more optional #753

Fixed

• Fixed an issue with arrays and cruds. #651
• Fixed handling of arrays for ROWS/COLUMNS functions. #677
• Fixed an issue with nested named expressions. #679
• Fixed an issue with matrixDetection + number parsing. #686
• Fixed an issue with NOW and TODAY functions. #709
• Fixed an issue with MIN/MAX function caches. #711
• Fixed an issue with caching and order of evaluation. #735

[0.6.2] - 2021-05-26

Changed

• Modified a private field in one of the classes to ensure broader compatibility with older TypeScript versions. #681

[0.6.1] - 2021-05-24

Changed

• Remove redundant 'assert' dependency from the code. #672

Fixed

• Fixed library support for IE11. The unorm package is added to the dependencies. #675