Added

• Added 12 database functions: DCOUNT, DSUM, DAVERAGE, DMAX, DMIN, DGET, DPRODUCT, DCOUNTA, DSTDEV, DSTDEVP, DVAR, DVARP. #1652
• Added new functions: PERCENTILE, PERCENTILE.INC, PERCENTILE.EXC, QUARTILE, QUARTILE.INC, QUARTILE.EXC. #1650
• Added maxPendingLazyTransformations configuration option to control memory usage by limiting accumulated transformations before cleanup. #1629
• Added a new function: TEXTJOIN. #1640
• Added a new function: SEQUENCE. #1645

Fixed

• Fixed a memory leak in LazilyTransformingAstService where the transformations array grew unboundedly, causing increasing memory usage over time. #1629
• Fixed a memory leak in UndoRedo where oldData entries for evicted undo stack entries were never cleaned up, causing increasing memory usage over time. #1629
• Fixed the IRR function returning #NUM! error when the initial investment significantly exceeds the sum of returns. #1628
• Fixed the ADDRESS function ignoring defaultValue when arguments are syntactically empty (e.g., =ADDRESS(2,3,,FALSE())). #1632

Added

• Added a new function: IRR. #1591
• Added a new function: N. #1585
• Added a new function: VALUE. #1592

Fixed

• Fixed Error Map maximum size exceeded error when loading big spreadsheets. #1602

Fixed

• Fixed an issue where cells were not recalculated after adding, removing and renaming sheets. #1116
• Fixed an issue where overwriting a non-computed cell caused the Value of the formula cell is not computed error. #1194

Changed

• Renamed the arraySizeMethod parameter in the FunctionMetadata interface to sizeOfResultArrayMethod. The arraySizeMethod is deprecated and will be removed in one of the next major releases. #1401
• Renamed the arrayFunction parameter in the FunctionMetadata interface to enableArrayArithmeticForArguments. The arrayFunction is deprecated and will be removed in one of the next major releases. #1401

Fixed

• Fixed an issue where the OFFSET function was ignoring the sheet reference in the provided address. #1477

Fixed

• Fixed Edge does not exist error when a named expression is used twice in the same formula. #1102
• Fixed typos in the built-in functions guide. #1517
• Fixed an issue where named expressions added on engine initialization were not updated on changes. #1501

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

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

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