hyperformula

Added

• Added method getNamedExpressionsFromFormula to extract named expressions from formulas. #1365
• Added context config option for passing data to custom functions. #1396

Changed

• Removed unorm dependency. #1370

Fixed

• Fixed an issue where operating on ranges of incompatible sizes resulted in a runtime exception. #1267
• Fixed an issue where the simpleCellAddressFromString() method was crashing when called with a non-ASCII character in an unquoted sheet name. #1312
• Fixed an issue where adding a row to a very large spreadsheet resulted in the Maximum call stack size exceeded error. #1332
• Fixed an issue where using a column-range reference to an empty sheet as a function argument resulted in the Incorrect array size error. #1147
• Fixed an issue where the SUBSTITUTE function wasn't working correctly with regex special characters. #1289
• Fixed a typo in the JSDoc comment of the HyperFormula class. #1323

Added

• Exported the EmptyValue symbol as a public API. This allows custom functions to handle empty cell
  values. #1232

Changed

• Improved the efficiency of the default date/time parsing
  methods. #876
• Improved the efficiency of the operations on the dependency
  graph. #876

Fixed

• Fixed a bug where neighboring exported changes of an array formula were
  missing. #1291

Added

• Added a new function: ADDRESS. #1221
• Added a new function: HYPERLINK. #1215
• Added a new function: IFS. #1157

Changed

• Optimized the updateConfig() method to rebuild HyperFormula only when the new configuration is different from the old one. #1251

Fixed

• Fixed the SEARCH function to be case-insensitive regardless of HyperFormula's configuration. #1225

Added

• Exported the CellError class as a public API. #1232
• Exported the SimpleRangeValue class as a public API. #1178

Fixed

• Fixed an EmptyCellVertex data integrity issue between the AddressMapping and DependencyGraph objects. #1188
• Fixed a build issue with M1- and M2-chip MacBooks. #1166
• Fixed an issue where the order of items returned by removeColumns() depended on the address mapping policy. #1205

Fixed

• Fixed an issue where expression names were not allowed to start with a cell
  reference. #1058
• Fixed an issue where expression names were allowed to start with R1C1-notation
  references. For better compatibility with other spreadsheet software, strings
  such as R4C5, RC1000, R1C or RC can't be used in expression names
  anymore. #1058
• Fixed an issue where using reversed ranges with absolute addressing could
  cause the Incorrect array size error. #1106
• Fixed an issue where removing a sheet (removeSheet()) without clearing it
  (clearSheet()) could cause an error. #1121

Added

• Exported the ArraySize class as a public API. #843
• Renamed an internal interface from ArgumentTypes to FunctionArgumentType, and exported it as a public API. #1108
• Exported ImplementedFunctions and FunctionMetadata as public APIs. #1108

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

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

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

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

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

Fixed

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

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)

Changed

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

Changed

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

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)

Fixed

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

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:

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

• Breaking change: Changed Exceptions #747:

• 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

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 a flag to getFillRangeData to support different types of offsetting. #767

Fixed

• Fixed an issue with arrays and cruds. #651
• Fixed handling of arrays for ROWS/COLUMNS functions. #677
• Fixed an issue with nested namedexpressions. #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

Changed

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

Changed

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

Fixed

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

Changed

• Breaking change: Moved GPU.js from dependencies to devDependencies and optionalDependencies. (#642)

Added

• Added two new fired events, for suspending and resuming execution. (#637)
• Added listing in scopes to listNamedExpressions method. (#638)

Fixed

• Fixed issues with scoped named expression. (#646, #641)
• Fixed an issue with losing formating info about DateTime numbers. (#626)