Released: Jun 1, 2021

Updates in V9.0.0

Features

• Added new formula plugin: HyperFormula.
  • High-speed formula calculations.
  • Function syntax compatible with Microsoft Excel and Google Sheets.
  • A library of 386 built-in functions available in 16 languages.
  • Support for wildcard characters.
  • Support for CRUD operations.
  • Support for cross-sheet references.
  • Support for multiple Handsontable instances.
  • Uses GPU acceleration for better performance.
• Improved performance.
• Upgraded eslint and eslint-related modules.
• Added fit and fdescribe to restricted globals in test files.

Fixes

• Fixed a problem with the column indicator of the Collapsible Columns plugin not being displayed properly on styled headers.
• Fixed a problem with duplicated afterCreateCol hooks being triggered after undoing a removal of a column.
• Fixed a problem with formulas not being calculated in certain conditions.
• Fixed a bug with formulas displaying incorrect values after inserting new rows.
• Fixed a problem with the AVARAGE formula being updated incorrectly.
• Fixed a problem with the IF formulas not working properly.
• Fixed a bug with using the clear method broke the formulas in the table.
• Breaking change: New Formulas plugin, with an entirely different API. Removed the required hot-formula-parser dependency for the sake of an optional one, hyperformula.
• Breaking change: Changed the afterAutofill and beforeAutofill hooks’ signatures.
• Breaking change: Removed the deprecated plugins – Header Tooltips and Observe Changes.
• Deprecated the beforeAutofillInsidePopulate hook.