Rock-solid data grid for web applications A JavaScript component that combines data grid features with spreadsheet-like UX. Legendary support included.Works with React, Angular, Vue, and plain JavaScript

Release notes

See the full history of changes made to Handsontable in each major, minor, and patch release.

12.2.0

Released on October 25, 2022

For more information on this release, see:

• Blog post(opens new window)
• Documentation(opens new window)

Added

• Added a new feature that lets you add rows and columns at a specified position. Now, the alter() method takes 4 new parameter values: insert_row_above, insert_row_below, insert_col_start, and insert_col_end. The insert_row and insert_col parameters are marked as deprecated. #9471(opens new window)

Fixed

• Fixed an issue where the width of the cell editor was calculated incorrectly. #3815(opens new window)
• Fixed an issue where formulas surrounded by merged cells were converted to values by mistake. #6359(opens new window)
• Fixed an issue where Handsontable could disappear on Firefox 93 (and later) in a specific use case. #9545(opens new window)
• Fixed an issue where changing a cell's type through setCellMeta() didn't properly set the cell's editor and renderer. #9734(opens new window)
• Fixed an issue where the dropdown menu didn't display when the NestedHeaders plugin was enabled and all rows were trimmed out. #9753(opens new window)

Removed

• Removed a type definition for a non-existing method, translateRowsToColumns(). #9919(opens new window)

12.1.3

Released on September 22, 2022

For more information on this release, see:

• Documentation(opens new window)

Fixed

• Fixed incorrect date format conversion on input in the date editor. #9681(opens new window)
• Fixed an error when adding a large number of rows using the alter method. #7840(opens new window)
• Fixed IME text input in the editors. #9586(opens new window)
• Fixed an issue where the editor did not open on key events when the cell was outside the viewport. #9022(opens new window)
• Fixed an issue with "0" values being ignored by the Column Summary plugin. #6385(opens new window)
• Fixed an error when opening the column dropdown menu with the Filters plugin enabled. #9561(opens new window)
• Fixed an issue where the trimWhitespace option could not be used in the column and cell levels of the cascading configuration. #7387(opens new window)
• Fixed the flickering of the selection area at the edge of the table while scrolling. #8317(opens new window)
• Fixed misalignment on mobile devices when the edge cells were selected. #9621(opens new window)
• Fixed type definitions for the method setSourceDataAtCell. #8599(opens new window)

Removed

• Removed a custom stable sorting implementation in favor of the stable sorting algorithm guaranteed by ECMAScript 2019 #6091(opens new window)
• Removed type definitions for non-existing methods rowOffset and colOffset and a non-existing hook modifyRowSourceData. #8659 (opens new window), #7317