Released: May 23, 2023

Updates in V12.4.0

Features

• Auto-updating formulas - Users can now modify their tables on the fly, with addresses in formulas updating themselves accordingly.
• Added two new Handsontable hooks: 'afterColumnSequenceChange' and 'afterRowSequenceChange' which are fired after changing the order of columns or rows.
• Improved copying/pasting to Microsoft Excel.

Fixes

• Fixed numerous issues related to syncing Handsontable with HyperFormula. Now, formulas work properly with all the Handsontable features.
• Fixed an issue where formulas didn't recalculate after rows or columns were moved.
• Fixed an issue where Handsontable's dates didn't sync correctly with HyperFormula's dates.
• Fixed an issue where calling updateSettings() would reset HyperFormula's undo/redo actions stack.
• Fixed an issue where the Autofill, TrimRows and Formulas plugins didn't work properly together.
• Fixed an issue where the modifySourceData hook used the wrong type of indexes.
• Fixed an issue where text copied from Handsontable to Excel included the wrong types of spaces.
• Fixed an issue where mousing over the same cell twice didn't trigger the beforeOnCellMouseOver and afterOnCellMouseOver hooks.
• Updated TypeScript definition files related to the CustomBorders plugin.
• Fixed an issue where moving rows manually to the bottom was difficult due to the misalignment between the backlight and guideline elements.