hyperformula - npm Package Versions

[3.0.0] - 2025-01-14

Added

• Added a new function: XLOOKUP. #1458

Changed

• Breaking change: Changed ES module build to use mjs files and exports property in package.json to make importing language files possible in Node environment. #1344
• Breaking change: Changed the default value of the precisionRounding configuration option to 10. #1300
• Make methods simpleCellAddressToString and simpleCellRangeToString more logical and easier to use. #1151

Removed

• Breaking change: Removed the binarySearchThreshold configuration option. #1439

[2.7.1] - 2024-07-18

Fixed

• Fixed an issue where adding or removing columns with DenseStrategy for address mapping resulted in the Cannot read properties of undefined (reading 'splice') error. #1406

[2.7.0] - 2024-04-10

Added

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

[2.6.2] - 2024-02-15

Changed

• Removed unorm dependency. #1370

[2.6.1] - 2023-12-27

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

[2.6.0] - 2023-09-19

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
• Fixed a typo in the source code of the MatrixPlugin. #1306

[2.5.0] - 2023-05-29

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

[2.4.0] - 2023-04-24

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

[2.3.1] - 2023-03-03

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

[2.3.0] - 2022-12-22

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