Released: Apr 28, 2022

Updates in V12.0.0

Features

• Added ShortcutManager, a new API for customizing keyboard shortcuts.
• Added support for right-to-left (RTL) languages, by introducing a new configuration option: layoutDirection.
• Added an Arabic translation.
• Added a new configuration option: fixedColumnsStart.
• Added a new keyboard shortcut (Ctrl/Cmd + Enter) for filling the selected range of cells with the value of the active cell.
• Added support for the Home and End keys inside cell editors, for moving the cursor to the beginning or end of the text.
• Added support for the latest Node LTS version.
• Breaking change: Changed how updateSettings() handles data updates, to improve performance and the consistency of user experience. Now, when provided with a new data object, updateSettings() updates the data without resetting any states.
• Breaking change: Changed how updatePlugin() reacts to updateSettings() calls, to improve performance and the consistency of user experience. Now, calls to updateSettings() update a plugin's state only when the options object contains a configuration option that's relevant to that particular plugin.
• Breaking change: Changed the order of execution for two hooks: now, beforeKeyDown is properly fired before afterDocumentKeyDown.
• Breaking change: Changed how default keyboard shortcuts are defined, to improve keyboard navigation consistency. Most of the shortcuts did not change and are now properly documented in the keyboard shortcuts guide. However, some shortcuts that were not defined explicitly, and were not listed in the documentation, don't work anymore (e.g., Enter opens a cell's editor, but Ctrl + Enter doesn't). This change doesn't affect custom keyboard shortcuts.
• Breaking change: Split a cross-platform modifier key (Ctrl/Cmd) into two separate keys, to improve keyboard navigation consistency. Now, the Cmd key triggers actions on Apple macOS where the Ctrl key triggers actions on Microsoft Windows. For example, on macOS, Ctrl + A doesn't work anymore: Cmd + A is used instead.
• Breaking change: Changed the actions of the following keyboard shortcuts, to match the usual spreadsheet software behavior, and provide a more intuitive user experience:
  • Ctrl/Cmd + ↑.
  • Ctrl/Cmd + Shift + ↑.
  • Ctrl/Cmd + ↓.
  • Ctrl/Cmd + Shift + ↓.
  • Ctrl/Cmd + ←.
  • Ctrl/Cmd + Shift + ←.
  • Ctrl/Cmd + →.
  • Ctrl/Cmd + Shift + →.
  • Home.
  • Ctrl/Cmd + Home.
  • End.
  • Ctrl/Cmd + End.
  • Shift + Page Up.
  • Shift + Page Down.
• Changed two scripts in the main Handsontable workspace (./), to speed up the build process. Now, the npm run build and npm run test scripts don't build or test the Handsontable examples (./examples).
• Changed version of Moment.js dependency from 2.24.0 to 2.29.3, in reaction to a recently-found Moment.js security vulnerability that did not directly affect Handsontable.
• Changed version of HyperFormula optional dependency from ^1.2.0 to ^2.0.0.
• Changed an internal property name, from handsontableInstance.view.wt to handsontableInstance.view._wt, to make it clear that Walkontable (Handsontable's rendering engine) is not a part of Handsontable's public API.
• Breaking change: Removed the Cmd + M keyboard shortcut (used for cell merging), as it conflicted with window minimizing on macOS. The Ctrl + M keyboard shortcut works the same as before.
• Breaking change: Removed the Shift + Page Up/Page Down keyboard shortcuts from the cell editing context.
• Dropped support for Microsoft Internet Explorer 11 and Microsoft Edge Legacy (the non-Chromium version of Edge). Handsontable 11.x becomes the long-term support (LTS) version for Internet Explorer 11 and Edge Legacy, until the end of 2023.
• React: Removed the enzyme dependency from the React wrapper.

Fixes

• React, Angular, Vue 2, Vue 3: Fixed an issue where using updateSettings() caused problems for state managers.
• Fixed an issue where using updateSettings() caused hidden columns to reappear.
• Fixed an issue where using updateSettings() caused merged cells to unmerge.
• Fixed an issue where using updateSettings() caused the state of nested rows to reset.
• Fixed an issue where using updateSettings() caused problems with column sorting.
• React: Fixed an issue where using React's setState() within the afterFilter hook broke filtering.
• Vue 2: Fixed an issue where repeatedly changing Handsontable's height through updateSettings() caused Handsontable to crash.
• Vue 2: Fixed an issue where the failed validation status got erased when editing a new row.
• Fixed an issue where cell filtering did not use formula results.
• Fixed a wrong TypeScript definition in the BasePlugin class.
• Fixed an issue where the Ctrl/Cmd + Z and Ctrl/Cmd + Shift + Z keyboard shortcuts didn't behave properly inside cell editors.
• Fixed an issue where the dropdown menu contained unwanted rectangle elements.
• React, Vue 2, Vue 3: Fixed an issue with registering modules for the React, Vue 2, and Vue 3 wrappers, by adding an "exports" field to their package.json files.