3.0.0

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

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

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

Changed

• Removed unorm dependency. #1370

2.6.1

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

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

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

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

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

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