Changelog 8.0
8.4.0
Released on May 11, 2021.
For more information on this release, see:
Added
- Introduced a
separatedattribute for the label options (thelabelDOM element may wrapinputor be placed next to it). (#3172) - Introduced the
modifyAutoColumnSizeSeedhook to let developers overwrite the default behaviour of the AutoColumnSize sampling. (#3339) - Added support for hiding columns for the
NestedHeadersplugin. (#6879) - Added ability to skip stacking actions by the
UndoRedoplugin and introduced new hooks. (#6948) - Added 2 new hooks,
beforeHighlightingColumnHeaderandbeforeHighlightingRowHeader. Use them to retrieve a header element (<th>) before it gets highlighted. (#7528) - Added a new method,
indexMapper.unregisterAll(). Use it to unregister all collected index maps from all map collections types. (#7528) - Added a new method,
indexMapper.createChangesObserver(). Use it to listen to any changes made to indexes while Handsontable is running. (#7528) - Added a new method,
indexMapper.createAndRegisterIndexMap(). Use it to create and register a new index map. (#7528)
Fixed
- Fixed a problem with sorting the
checkbox-typed cells and an issue with empty cells not being displayed properly. (#4047) - Fixed a problem where undoing the removal of row with
readOnlycells was not performed properly. (#4754) - Fixed state-change resolving for externally added checkboxes. (#5934)
- Fixed a problem with the native selection being removed with the
fragmentSelectionoption enabled. (#6083) - Fixed a bug where number of columns rendered in the viewport was not correct. (#6115)
- Fixed a bug with the Dropdown Menu not opening on Android devices. (#6212)
- Fixed the double-tap issue on iOS. (#6961)
- Fixed a problem with the Comments editor being destroyed after destroying another Handsontable instance. (#7091)
- Fixed incorrect
numericFormat’s type definition. (#7420) - Fixed the
trimWhitespacetests on Firefox. (#7593) - Fixed the [NPM Audit] Github Action job to report found vulnerabilities. (#7621)
- Fixed some minor iOS problems. (#7659)
- Fixed the TypeScript definition for the suspended rendering feature. (#7666)
- Fixed the
postbuildandexamples:installscripts on Windows. (#7680) - Fixed the contents of the production
package.json. (#7723) - Fixed an issue, where the callbacks for the
UndoRedoplugin were called twice. (#7825) - Vue: Fixed a problem with displaying and removing rows in the
NestedRowsplugin. (#7548) - React: Fixed an incompatibility in the property type definitions for the HotColumn component. (#7612)
Changed
- Enhanced the ESLint config file by adding a rule that checks if there are new lines missing before some keywords or statements. (#7691)
8.3.2
Released on March 16, 2021.
For more information on this release, see:
Added
- Introduced the monorepo to this repository. From now
on,
handsontable,@handsontable/angular,@handsontable/react, and@handsontable/vuewill all be developed in the same repo -handsontable. (#7380) - Added a custom ESLint rule which allows restricting specified modules from loading by
importor re-exporting. (#7473)
Fixed
- Fixed a bug where it was impossible to enable
disableVisualSelectionfor cells/columns. (#5082) - Fixed wrong paddings for multi-level headers. (#5086)
- Fixed problems with the
currentoption of thedisableVisualSelectionsetting. (#5869) - Fixed problems with the
headeroption of thedisableVisualSelectionsetting. (#6025) - Fixed a bug where the “double-tap-to-zoom” gesture prevented the editor from opening properly on some mobile devices. (#7142)
- Fixed a bug where calling the
updateSettingsmethod in the body of some callbacks would break the table. (#7231) - Fixed an issue where the
maxRowsandmaxColsoptions interfered with hidden index calculations. (#7350) - Fixed problems with doubled borders being displayed when
windowwas a scrollable container. (#7356) - Fixed a bug where value population from an edited cell would result in a console error. (#7382)
- Fixed a bug where the dropdown cell type would not work on Safari 14+. (#7413)
- Fixed a bug where the
AutoRowSizeplugin would break the table when placed in an iframe. (#7424) - Fixed bugs in navigation by
HOMEandENDkeys with hidden rows/columns enabled. (#7454) - Fixed a bug with the
trimWhitespaceoption not working properly. (#7458) - Fixed an issue with inconsistent documentation and TypeScript definitions
for
colWidthsandrowHeightsoptions. (#7507) - Fixed the incorrect
cellTypesmodule paths in theexportsentry of thepackage.jsonfile. (#7597) - Vue: Fixed Remote Code Execution vulnerability in the dev dependencies. (#7620)
8.3.1
Released on February 10, 2021.
For more information on this release, see:
Fixed
- Fixed an issue where the CSS files could be eliminated during tree-shaking. (#7516)
8.3.0
Released on January 28, 2021.
For more information on this release, see:
Added
- Introduced a new feature that allows postponing the table render and internal data cache update.
The table rendering time can be reduced several-fold times by batching (using the
batchmethod), multi-line API calls, or manually suspending rendering using thesuspendRenderandresumeRendermethods. (#7274) - Introduced a possibility to import:
- plugins
- cell types
- editors
- renderers
- validators as separate modules, along with the Handsontable base. This change allows utilizing only the parts of Handsontable the end application is actually using, without the overhead of the full bundle. (#7403)
- Added a new workflow for managing and generating changelogs. (#7405)
Fixed
- Fixed a bug with auto-execution of the first item in the
ContextMenuplugin. (#7364) - Fixed a bug where column sorting with multi column sorting crashed the table. (#7415)
- Added a missing entry for the
skipRowOnPasteoption in the TypeScript definition file. (#7394) - Added missing tests to prevent issue #7377 from resurfacing. (#7396)
- Fixed an issue where altering columns did not update filters attached to columns. (#6830)
- Fixed typos and wrong return types in the TypeScript definition file. (#7399)
- Updated the dependencies causing potential security issues, as well as Babel configuration needed after the update. (#7463)
Changed
- Corrected a typo in a helper method from the
ColumnSortingplugin. (#7375) - Optimized the performance of rendering the table with numerous spare rows (for
minSpareRows,minSpareCols,minRows, andminColsoptions). (#7439)
8.2.0
Released on November 12, 2020.
For more information on this release, see:
Added
- Added a new type of an Index Map named
LinkedPhysicalIndexToValueMap. (#7276) - Added an external dependency,
DOMPurify, to add HTML sanitization that should minimize the risk of inserting insecure code using Handsontable built-in functionalities. (#7292)
Fixed
- Fixed an issue where the container was not updated after trimming rows. (#7241)
- Fixed an issue where the
htmlToGridSettingshelper threw an error if a<table>with no rows was passed. (#7311) - Fixed an issue where the sorting indicator moved incorrectly when a column was added. (#6397)
- Fixed an issue where untrimming previously trimmed rows would sometimes result in the table instance not refreshing its height, leaving the row headers improperly rendered. (#6276)
- Fixed an issue where the hidden columns plugin caused unintended scrolling when some cells were hidden. (#7322)
- Fixed an issue where an error was thrown while hovering over row/column headers. (#6926)
- Fixed an issue where table validation caused incorrect data rendering if the hidden rows/column plugin was enabled. (#7301)
- Fixed an issue where adding 0 rows to the table ended with doubled entries in index mappers’ collections. (#7326)
- Fixed a problem with the inconsistent behavior of the Context Menu’s “Clear column” disabled status. (#7003)
- Fixed an issue with parsing multiline cells on pasting
text/htmlmime-type. (#7369)
8.1.0
Released on October 1, 2020.
For more information on this release, see:
Added
- Added support for resizing non-adjacent selected rows and columns. (#7162)
- Added e2e tests and reorganized already existing ones. (#6491)
Changed
- Updated dependencies to meet security requirements. (#7222)
- Improved performance for
TrimRows,HiddenRowsandHiddenColumnsplugins for big datasets with many trimmed/hidden indexes. (#7223)
Fixed
- Fixed an issue where the value did not show if the first part of the merged area was hidden. (#6871)
- Fixed an issue where after selecting the top-left element, resizing the row range was not possible. (#7162)
- Fixed a bug introduced within (#6871)
- Fixed an issue where column headers were cut off after hiding and revealing the columns with the
HiddenColumnsplugin. (#6395) - Fixed an issue where a redundant row was added during copy/paste operations in some cases. (#5961)
- Fixed an issue where too many values were pasted after a column was hidden. (#6743)
- Fixed a bug where an attempt to move collapsed parent rows, with the
NestedRowsplugin enabled, resulted in an error. (#7132) - Fixed an issue where, after column or row alteration, Handsontable threw an error if
ColumnSummarywas enabled without defined row ranges. (#7174) - Fixed an issue where using
updateSettingswas breaking column sorting in specific cases. (#7228) - Fixed an issue where, if
fixedColumnsLeftwas defined, rows had their left borders missing after disabling the row headers usingupdateSettings. (#5735) - Fixed an issue where the Handsontable instance could fall into an infinite loop during vertical
scrolling. It only happened when the scrollable element was the
windowobject. (#7260) - Fixed an issue with moving rows to the last row of the table when the
NestedRowsplugin was enabled. Repaired some other minor moving-related bugs as well. (#6067) - Fixed an issue with adding an unnecessary extra empty line in cells on Safari. (#7262)
- Fixed an issue with clipped column headers when they were changed before or within usage of
updateSettings. (#6004)
8.0.0
Released on August 5, 2020.
For more information on this release, see:
Major changes
This version introduces a completely new architecture for row and column management - index mapper, which is responsible for the storage and management of index values. In prior versions, the calculation between physical and visual indexes was based on callbacks between hooks. That solution slowly led to inconsistencies and the calculation was imperfect in some cases. To fix that there was a major change in the whole system of mapping the indexes. The current solution offers an easier and more straightforward way to perform CRUD and move operations on rows and columns. It keeps all data in one place so getting and managing information is easier and less prone to bugs.
The existing features were adapted to benefit from the new architecture. Apart from that, extra methods and hooks were added and there are few depreciations and removals, too.
Breaking changes
- Modifying the table’s data by reference and calling
render()will not work properly anymore. From this point onward, all the data-related operations need to be performed using the API methods, such aspopulateFromArrayorsetDataAtCell. - The
modifyRow,modifyCol,unmodifyRow,unmodifyColhooks are no longer needed and were removed. Their functionality can be achived by using API. More information in the 8.0.0 migration guide. skipLengthCachehook was removed,indexMapperis now responsible for the cache and length.- The
ManualColumnFreezeplugin doesn’t use theManualColumnMoveplugin anymore. - The
CollapsibleColumnsplugin doesn’t use theHiddenColumnsplugin anymore. - The
NestedRowsandFiltersplugins don’t use theTrimRowsplugin anymore. - The
minSpareRowsandminRowsoptions will ensure that the number of visible rows corresponds to the value provided to them (for example, theTrimRowsplugin won’t have an impact on the number of displayed rows). toPhysicalRowandtoVisualColumnnow returnnullfor non-existant rows/columns. #5945).- The
afterLoadDatahook receives a different set of arguments. It used to be just the initialLoad flag, now the first argument issourceData, followed byinitialLoad. - The
ManualColumnFreezeplugin will now put the unfrozen columns right next to the last frozen one. - The
RecordTranslatorobject and thetproperty available in the plugins were removed. - After-prefixed hooks (
afterLoadData,afterFilter, etc.) are now called just before therendercall. - Newly created rows and columns are now placed in the source data in the place calculated from its position in the visual context (they “stick” to their adjacent rows/columns). It also applies to moved rows and columns.
- When the
NestedRowsplugin isenabled, moving rows will be possible only using the UI or by calling thedragRowsmethod of theManualRowMoveplugin. - The
beforeRowResize,afterRowResize,beforeColumnResize,afterColumnResizehooks have the order of their arguments rearranged for the sake of consistency with other hooks and to fix an issue where multiple hooks didn’t get the modified value in the pipeline: #3328. - Changed the argument structure in
collapsibleColumns’toggleCollapsibleSectionmethod: #6193. - The following sublist shows changes related to the refactor of
HiddenColumnsandCollapsibleColumns. They will be compatible with upcomingIndexMappers#5945 along with other adjustments #6547:- Hidden indexes aren’t rendered. As a consequence hooks
beforeValueRender,beforeRenderer,afterRenderer,modifyColWidth,beforeStretchingColumnWidthetc. will be executed just for some of the columns (just the rendered ones). - The
getColWidthfor hidden index will return 0 – it used to return 0.1. Also, it will no longer be called internally, the need can be now achieved by managers of rows and columns. - The
modifyColWidthhook will not be called internally. However, it will be executed when the user will call thegetColWidth. - Hidden indexes aren’t rendered. As a consequence hooks
beforeValueRender,beforeRenderer,afterRenderer,modifyColWidth,beforeStretchingColumnWidthetc. will be executed just for some of the columns (just the rendered ones). listenfunction from the core API used to acceptmodifyDocumentFocusas optional parameter, this parameter was removed.CustomBordersplugin was adapted to work withHiddenColumnsproperly. From now on hiding cells at the start or the end of the range will also hide their borders. Hiding a single cell with borders will hide all of its borders. #7083.CollapsibleColumnswill no longer useHiddenColumnsplugin to work. #6204.- Adjusted
HiddenColumnsto be compatible with upcomingIndexMappers. #6547. hiddenRowandhiddenColumnhooks were removed. They were used to check if a given index is hidden in theHiddenColumnsandHiddenRowsplugins. Since now there may be more sources of hiding indexes they have been replaced byIndexMapperwith the newisHiddenmethod. It keeps the broad information about hidden indexes and their sources.rowOffsetandcolOffsetwere removed since they aliased the methods from Walkontable. #6547.
- Hidden indexes aren’t rendered. As a consequence hooks
- Changes related to adjusting
HiddenRowsto newIndexMapperarchitecture are #6177:- Adjusted
HiddenRowsto newIndexMapperarchitecture. #6177.
- Adjusted
- Developed a unified way to identify HOT “input” elements. All input elements owned by HOT got an attribute “data-hot-input” which are identified by that key. #6383.
NestedHeadersplugin was rewritten, from now on, only a tree-like structure will be allowed, meaning, there will be no possibility to place nested headers in-between layers. #6716- The right mouse button (
RMB) click on the corner when there is no data will show all options disabled. #6547. - Left mouse button (
LMB) click on the top left corner will now select all cells along with their headers. #6547. - Removed the experimental
GanttChartplugin. #7022. - Adding properties which were not defined on initialization or by
updateSettingsto the source data is possible only by the usage ofsetSourceDataAtCell. #6664. - Passing
columnsordatainside thesettingsobject when calling theupdateSettingsmethod will result in resetting states corresponding to rows and columns (ie. row/column sequence, column width, row height, freezed columns etc.). The same behavior can be seen when usingloadData. In such cases, it is assumed that a new dataset is introduced upon callingupdateSettingsorloadData.#6547.
New features
- Added the Index Mapper architecture and its API. #5112 (more information available in the PRs #5945 with additional changes in #6547)
- Added a new
batchmethod. #5945 along with other adjustments (#7068)
Deprecations
- The
ObserveChangesplugin is no longer enabled bycolumnSortingand became deprecated. #5945 HeaderTooltipsplugin becomes deprecated and will be removed in the next major version. #7023- IE support is deprecated and will be removed by the end of the year. #7026
Changelog
- Added
modifySourceDatahook andsetSourceDataAtCellmethod. #6664 - Added new argument to
scrollViewportTomethod: optionalconsiderHiddenIndexeswhich is aboolean. #6547 - Added additional information available in the cell meta object - the language. #6254.
- Added a possibility to allow cancelling of
autofillin thebeforeAutofillhook. #4441 - Added support for newer versions of moment, numbro and pikaday. #5159
- Added
afterAutoFillhook. #6135 - Added deprecated warning messages mechanism for plugin hooks. #6613
- Added missing types for `instance.undoRedo`. #6346
- Added
countRenderableColumnsmethod to theTableView. #6177 - Added missing “hide” property in
CustomBorderstypings. #6788 - Added
beforeSetCellMetahook with an ability to cancel the changes. #5388 - Added additional test for autofill plugin. #6756
- Changed how
ManualRowMoveandManualColumnMoveplugins work #5945 - Click on a row header will select all cells (also hidden). #2391
- Extracted Cell-Meta logic from Core to separate module. #6254
- The
CellMetamanager was refactored for future features and improvements. #6233 - Rows can be resized to less than
rowHeights. #6149 - Left mouse button (LMB) click on the corner will now select all cells. #6547
- Passing
columnsordatainside thesettingsobject when calling theupdateSettingsmethod will result in resetting states corresponding to rows and columns (ie. row/column sequence, column width, row height, freezed columns etc.). The same behavior can be seen when usingloadData. In such cases, it is assumed that a new dataset is introduced upon callingupdateSettingsorloadData.#6547. - The right mouse button (
RMB) click on the corner, column and row headers will show just some options, defined by newly created specification #7082 - Hidden indexes will no longer be rendered, as a consequence
afterRenderer,modifyColWidth,beforeStretchingColumnWidthwill be executable only on visible (meaning, rendered) rows and columns. #6547 - The
getColWidthfor hidden index will return 0 - it used to return 0.1 #6547 - The
modifyColWidthhook isn’t called internally. However, it will be executed when the user will call thegetColWidth. #6547 - Hidden rows/columns won’t rendered anymore. As a consequence hooks
beforeValueRender,beforeRenderer,afterRenderer,modifyColWidth,beforeStretchingColumnWidthetc. will be executed just for some of the columns (just the renderable ones). #6547 - Selection behavior changed when hiding cells from the
ContextMenu, now it is selecting a column on the right when there is space on right to the last selected column, selecting a column on the left otherwise. #6547 - Developed a unified way to identify HOT “input” elements. All input elements owned by HOT got an attribute “data-hot-input” which are identified by that key. #6383
NestedHeadersplugin was rewritten, from now on, only a tree-like structure will be allowed, meaning, there will be no possibility to place nested headers in-between layers. #6716CustomBordersplugin was adapted to work withHiddenColumnsproperly, from now on hiding cells at the start or at the end of a range will also hide their borders. Also, hiding a single cell with borders will hide all of its borders. #7083CollapsibleColumnswill no longer useHiddenColumnsplugin to work. #6204- Modifying the table’s data by reference and calling `render()` will not work properly anymore.
From this point onward, all the data-related operations need to be performed using the API
methods, such as
populateFromArrayorsetDataAtCell. #5945 - Removed dependencies between plugins: the
ManualColumnFreezeplugin doesn’t use theManualColumnMove, theCollapsibleColumnsplugin doesn’t use theHiddenColumnsplugin,NestedRowsplugin doesn’t use theTrimRowsplugin,Filtersplugin doesn’t use theTrimRowsplugin anymore. #5945 along with other adjustments [#6547](https:// github.com/handsontable/handsontable/pull/6547): - The
minSpareRowsandminRowsoptions will ensure that the number of visible rows corresponds to the value provided to them (for example, theTrimRowsplugin won’t have an impact on the number of displayed rows). #5945 toPhysicalRowandtoVisualColumnnow returnnullfor non-existant rows/columns. #5945- The
afterLoadDatahook receives a different set of arguments. It used to be just the initialLoad flag, now the first argument issourceData, followed byinitialLoad. #5945 - The
ManualColumnFreezeplugin unfreezes the column just after the “line of freeze”. #5945 - The
RecordTranslatorobject and thetproperty available in the plugins were removed. #5945 - After-prefixed hooks (
afterLoadData,afterFilter, etc.) are now called just before therendercall. #5945 - Newly created rows and columns are now placed in the source data in the place calculated from its position in the visual context (they “stick” to their adjacent rows/columns). It also applies to moved rows and columns. #5945
- When the
NestedRowsplugin isenabled, moving rows will be possible only using the UI or by calling thedragRowsmethod of themanualRowMoveplugin. #5945 - The
beforeRowResize,afterRowResize,beforeColumnResize,afterColumnResizehooks have the order of their arguments rearranged for the sake of consistency with other hooks. #3328 - Changed the argument structure in
collapsibleColumns’toggleCollapsibleSectionmethod. #6193 - Updated the
moment,numbroandpikadaydependencies to their latest versions. #6610 - Standardize the `z-index` properties between the overlays. #6269
HeaderTooltipsplugin becomes deprecated and will be removed in the next major version. #7023- IE support is depreacated and will removed by the end of the year. #7026
- Removed
firstVisibleColumnCSS class as no longer needed. #6547 - Removed helpers that covered IE8 support or are not needed anymore. #6525
- Removed old unnecessary warning about
beforeChangecallback. #6792 - Removed
debugkey (key, css, docs). #6672 - Removed
hiddenRowandhiddenColumnhooks. #6547 - Removed optional argument
modifyDocumentFocusfrom thelistenfunction. #6547 - Removed
rowOffsetandcolOffsetpublic API methods since they aliased the methods from Walkontable. #6547 - Removed the experimental
GanttChartplugin. #7022 - Removed post-install warning from package.json file #6608
- The
modifyRow,modifyCol,unmodifyRow,unmodifyColandskipLengthCachehooks are no longer needed and were removed. #5945 - Fixed a problem with data not being added to the table properly with the
columnSortingoption enabled. #2685 - Fixed a problem with
loadDatanot resetting the row order changed by theManualRowMoveplugin. #3568 - Fixed a bug, where using
alter’sinsert_rowafter using theloadDatamethod and sorting the data would add unintentional additional rows to the table. #3809 - Fixed a bug, where blank rows appeared in the middle of the table after using
loadDataalong with theminSpareRowsoption. #3937 - Fixed a problem with the
ColumnSummaryplugin not working properly after adding new rows using the Context Menu and sorting the data. #3924 - Fixed a bug, where calling
loadDatawith an object-based data source would not work properly. #4204 - Fixed a problem with the Hidden Columns settings being reset after calling
updateSettings. #4121 - Fixed a bug with the
Filtersplugin using incorrect indexes after moving and/or sorting the table. #4442 - Fixed a bug that caused a column to contain improper data after moving it to index
0. #4470 - Fixed a bug with the
afterRowMovehook receiving an impropertargetargument. #4501 - Fixed a problem with the
ManualColumnFreezeplugin enablingManualColumnMove, even if it was declared asfalse. #4553 - Fixed a problem with plugins using
arrayMappersnot working properly after updating the dataset. #4567 - Fixed a bug, where calling
loadDatawithminSpareRowsandmanualRowMoveenabled caused the table to improperly load the data. #4576 - Fixed a bug, where enabling
columnSortingcaused themanualColumnFreezeto be unusable. #4601 - Fixed a problem, where the columns were assigned improper widths after inserting additional columns or removing any of them. #4666
- Fixed a bug, where moving rows was impossible while
persistentStatewas enabled. #4713 - Fixed a bug, where
manualColumnMovedidn’t work if the dataset was empty. #4926 - Fixed a bug with the
collapseAllmethod from thecollapsibleColumnsplugin did not work properly ifcolumnSortingwas enabled. #4999 - Fixed a bug, where calling
loadDatawithminSpareRowsenabled would cause unwanted blank rows to appear. #5707 - Fixed a bug with the
afterColumnMovehook receiving an impropertargetargument. #5173 - Fixed a problem, where filtering data after moving rows would not work properly. #5178
- Fixed a bug, where calling
loadDatamadeNaNappear in the column headers. #5369 - Fixed a bug with the
skipColumnOnPasteoption not working properly when usingcolumnSortingandhiddenColumns. #5824 - Fixed a bug with the
TrimRowsplugin did not work properly after moving rows. #5860 - Fixed a problem with
minSpareRowsnot working properly with thetrimRowsplugin being used. #5862 - Fixed a problem, where it was impossible to filter the data declared in the
NestedRowsplugin . #5889 - Fixed a bug, where filtering and sorting data would cause the
toVisualRowmethod to return the wrong results. #5890 - Fixed a bug with the
filtersandtrimRowsplugins not working properly alongside each other. #5915 - Fixed a bug, where
manualColumnMovewould not work properly when the data object properties count would be lower than the table column count. #5931 - Fixed a bug with the
TrimRowsplugin did not work properly with thestartRowsoption. #5953 - Fixed a problem, where using
loadDataafter sorting would not work as expected. #5956 - Fixed a problem with the
beforeColumnMoveandafterColumnMovehooks not containing information about their destination indexes. #6005 - Fixed a problem where using
filtersandminSpareRowswould make the table add an empty row at the beginning of the table. #6278 - Fixed a bug with the
manualRowMoveplugin would duplicate data in the moved rows, when used with a row index greater than the table row count. #6088 - Fixed a bug, where the
toVisualRowmethod returnednullwhen using thetrimRowsandcolumnSortingplugins together. #6310 - Fixed a problem, where calling
updateSettingsin theafterColumnMovehook callback would have no effect. #4480 - Fixed a bug, where calling
loadDatawould make thefiltersplugin to not behave as expected. #5244 - Fixed a bug, where detaching a child from a parent in the
NestedRowsplugin would cause a `+/-` button misalignment. #5900 - Fixed a problem with the
ColumnSummaryplugin creating a doubled summary row. #5794 - Fixed a bug, where moving children between parents using the
NestedRowsplugin would throw an error. #6066 - Fixed a bug, where adding rows by modifying the data by reference while using the
NestedRowsplugin would throw an error. #3914 - Fixed a bug, where merging cells would conflict with the
columnSortingplugin. #6086 - Fixed a bug, where the row headers would stay visible after removing all the table columns. #6412
- Fixed an issue where Hidden columns become visible when the user ran
updateSettings. #4121 - Fixed an issue where using
hiddenColumnsandstretchHshowed a redundant horizontal scrollbar. #4181 - Fixed an issue in which if the last column was a hidden column and
stretchHwas enabled, the last column was displayed. #4370 - Fixed an issue where
updateSettingsperformance was very low because ofhiddenColumnsbeing rendered. #4381 - Fixed an issue where collapse was not working correctly with custom cell renderers. #4716
- Fixed an incorrect header name when user defined more columns in the
NestedHeadersplugin. #4716 - Fixed an issue where
HiddenColumnsdid not work properly withColumnSorting. #5571 - Fixed an issue where
ManualColumnMoveshould work withHiddenColumns. #5598 - Fixed an issue where
hiddenColumnsoption interfered with the keyboard movement. #5704 - Fixed an issue where after hiding the first two rows, the row headers became de-synchronized by 1px. #5817
- Fixed an issue where hiding columns affected selection of hidden columns. #5871
- Fixed an issue where if
collapsibleColumnswere set totrueit was impossible to exit selection mode. #5875 - Fixed an issue where
hiddenColumnsdid not work properly with `autoWrapRow/autoWrapCol`. #5877 - Fixed an issue on IE where hiding the first column caused a display of double border for top left corner. #5881
- Fixed an issue where
nestedHeadersduplicated a header name if more columns are added. #5882 - Fixed an issue where
HiddenColumnsplugin unset cell’srenderer. #5883 - Fixed an issue where
hiddenColumnshad stored visual indexes and should have used physical indexes. #5909 - Fixed an issue where hidden columns should be unrecoverable. #6113
- Fixed an issue where row selection ignored columns that are hidden at the end. #6181
- Fixed an issue where defining data with more data than used in
columnscaused an issue with showing column once it was hidden. #6426 - Fixed an issue where hiding rows, while there was a merged area, involved caused data shifting and unexpected merged area coordinates. #6376
- Fixed an issue where
colHeaderwas truncated after movinghiddenColumn. #6463 - Fixed an issue where the last hidden column was visible upon column resizing. #6557
- Fixed an issue where with hiding columns after moved them manually. #6668
- Fixed an issue where expanding a collapsed column caused expanding of a child columns except for the first one. #5792
- Fixed an issue where setting
columnSortingtotrue(on initialization or viaupdateSettings) made headers non-collapsible programmatically viacollapseAllmethod. #4999 - Fixed an issue where
CustomBordersplugin was missing in the definition file. #6477 - Fixed incorrect size of
wtHiderandwtHolderin overlays. #3873 - Fixed an issue where
updateSettingscould not updatetableClassName. #6295 - Fixed an issue where JSON data with empty value was losing some double quotes when pasted into a cell. #6167
- Fixed an issue where some classes for the table were missing if one of them was empty. #6371
- Fixed an issue where clicking in a contextmenu’s border opened the native context menu. #6218
- Fixed the error that ocurred during loading of E2E test runner in Edge and IE. #6713
- Fixed the inconsistency and problems with adding rows from the corner when all rows are trimmed. #7061
- Fixed an issue where using read-only and alignment from the context menu was disabled when all columns were selected. #7114
- Fixed an issue where setting focus to a column to open context menu after applying a filter was impossible. #7005
- Fixed an issue where
minSpareColswithundoadded too many columns. #6363 - Fixed the inconsistency in selection when using the right mouse button for first row/column. #6334
- Fixed an issue where undoing column removal caused column headers to lack a header. #6992
- Fixed an issue where
readOnlyfor column was erased (did not apply) if filters were used. #6559 - Fixed an issue where readonly property was lost after declining confirmation in
beforeRemoveColorbeforeRemoverow. #6332 - Fixed an issue where
readOnlystate for some cells was lost when rows withtrimRowsturned on were removed. #6990 - Fixed incorrect column header highlight when merged cells were unmerged and
hiddenColumnswere used. #6978 - Fixed an issue where after hiding the first row, the second row top border disappeared. #6977
- Fixed an issue with incorrect selection after hiding the first row. #6831
- Fixed an issue where hiding the first row caused blue highlight in column headers selection to disappear. #6976
- Fixed wrong selection area after sorting with hidden rows. #6386
- Fixed an issue where it was not possible to use
selectAllwhen the first row was hidden. #6975 - Fixed an issue where it was possible to select hidden row or column. #6974
- Fixed an issue where row indexes changed if the first row was hiding after moving row from bottom to top. #6965
- Fixed an issue where selection skipped the highest parent. #6770
- Fixed an iisue where
nestedRowsblocked table from loading if data was not provided. #6928 - Fixed an isse where it was impossible to go back to the original cell after dragging down. #4233
- Fixed an issue where keyboard navigation did not work on merged cells with hidden rows/columns. #6973
- Fixed an issue where
trimRowsandhiddenRowswith specific settings broke borders. #6904 - Fixed wrong union type for
startPosition. #6840 - Fixed type mismatch for `Handsontable.plugins.ContextMenu`. #6347
- Fixed an issue where
manualColumnMovedid not modify thecolumnsinupdateSettings. #5200 - Fixed rendering issue on column udpate with
updateSettings. #3770 - Fixed an issue where expanding a collapsed column was also expanding ‘child’ collapsed columns, except the first child. #5792
- Fixed an issue with inproper selection for headers when the first column was hidden. #5999
- Fixed an issue where it was not possible to align cells if the selection was made upward. #6600
- Fixed an issue where
currentColClassNamedid not work properly withnestedHeaders. #5861 - Fixed an issue with scrollbar and dimension calculation in Firefox for toggling column visibility
with fixed columns and
stretchH. #6186 - Fixed an issue with undoing the nested row removal. #6433
- Fixed an isse where
getSourceDatafunctions returned wrong data for nested rows. #5771 - Fixed na issue where the
Formulasplugin did not work withnestedRows. #4154 - Fixed an issue where nested headers and hidden columns highlighted ad additional column when used together. #6881
- Fixed an issue where
getByRangefor sourceData did not work properly with nested object data. #6548 - Fixed an issue where `window.frameElement` threw errors in MSEdge, IE and Safari. #6478
- Fixed an issue where `DataSource.countColumns` returned invalid number of columns for nested objects. #3958
- Fixed an issue where
mergedCellswith hidden cells caused problems with rendering. #7020 - Fixed an issue where it was not possible to move column when all columns were selected by `ctrl + a`. #6355
- Fixed an issue where double click on the column resize handle did not adjust size correctly. #6755
- Fixed an issue where the cell meta was retrieved using the wrong coordinates. #6703
- Fixed nested rows incorrect state after changing data. #5753
- Fixed an issue in EDGE where the dropdown menu
onMouseOutevent caused critical errors when hovering over vertical scrollbar. #6699 - Fixed an issue with too many layers of highlight with noncontinuous selection on merged cells. #7028
- Fixed an issue where
NestedHeadersdid not allow to define header level as an empty array. #7035 - Fixed an issue where passing
nestedHeadersas a single empty array stoped the table from rendering. #7036 - Fixed an issue where opening a context menu for a column when its hidden data was selected did not block adding of rows by the menu. #7050
- Fixed an issue where it was not possible to navigate past hidden column using keyboard if`
hot.updateSettings` was called in
afterSelection. #3726 - Fixed an issue where headers did not export with
exportToFilein the specific case. #4176 - Fixed an issue with types mismatch. #6035
- Fixed an issue where manual row resize handler threw an error when bottom rows overlay was enabled. #6435
- Fixed an issue where the
afterRowResizehook shared incorrect results in the second parameter. #6430 - Fixed an issue where the row/column resize hooks should not have returned
null. #7074 - Fixed the loss of selection after merging from headers. #7076
- Fixed an issue where calling
updateSettingschanged the index of frozen columns viafreezeColumnmethod. #6843 - Fixed an issue where deleting the last column via
updateSettingswhich was part of the selection caused scroll to the bottom. #5849 - Fixed an issue where it was not possible to hide rows and merge cells at the same time. #6224
- Fixed the wrong data in merge cells after the hidden column and additionally an error occurs. #6888
- Fixed an issue where it was not possible to change cell type via
setCellMeta. #4793 - Fixed an issue where cell editor did not dynamically changed while changing the cell type. #4360
- Fixed an issue where it was not possible to unmerge cells if part of them was hidden. #7095
- Fixed an issue where calling
clearmethod removed the focus from the table. #7099 - Fixed an issue where
clearmethod did not work for hidden data. #7097 - Fixed an issue where the editor was moved by 1px when the first row / column was hidden. #6982
- Fixed an issue where headers were deselected after undoing removal. #6670
- Fixed an issue with improper selection after insert column/row when mergeCells was enabled. #4897
- Fixed an issue where wrong cell meta was removed when deleting rows. #6051
- Fixed wrong types of
beforeRowMovearguments. #6539 - Fixed an issue where selection of a whole row did not happen consequently after selecting a row header. #5906
- Fixed an issue where it was not possible to use physical row index instead of visual one. #6309
- Fixed an issue where incorrect data was returned after undoing the remove column option. #5000
- Fixed - Copy and paste works properly also when selecting hidden columns when: all columns within a selected range are hidden and when just some columns within a selected range are hidden. #7043.
- Fixed an issue where it was impossible to add new row in the
nestedRows. #5133 - Fixed an issue where
afterOnCellMouseDownreturned (0,0) coords after clicking on the topleft corner. #3978 - Fixed an issue where persisted
manualColumnMovewas not restored when usingloadData. #5207 - Fixed issues with filtering results in blank rows. #5208
- Fixed an issue where changing data on collapsed rows resulted in error. #5328
- Fixed an issue where the
manualColumnMoveoperation affected the column order of data loaded byloadData. #5591 - Fixed an issue where
nestedRowsdid not allow to keeprowHeadersafter collapsing. #5874 - Fixed performance and CPU issue caused by using some handsontable properties. #6058
- Fixed an error with the
ColumnSummaryplugin when trying to create a row. #6300 - Fixed an error where `walkontable.css` and `handsontable.css` stylesheets were out of sync. #6381
- Fixed an issue where
colHeadersorder was not updated after manual move with empty object data source. #6413 - Fixed “detach from parent” option. #6432
- Fixed an issue where
PreventOverflowfeature did not work ifMultiColumnSortingplugin was enabled. #6514 - Fixed an issue where old CSS classes were not removed after
updateSettings. #6575 - Fixed an issue where
columnSummary,Filtersand spare rows were causing ‘RangeError: Maximum call stack size exceeded’. #6695 - Fixed an issue where
afterSelectionEndreturned incorrect data when clicking on a column when all rows were hidden. #7045 - Fixed an issue where wrapping was not applied after setting
trimWhitespacetofalse. #6232 - Fixed an issue with additional selection border in iOS. #7103
- Fixed an issue with rendering different borders. #6955
- Fixed an issue with
BACKSPACEnot working properly in the filter by value input. #6842 - Fixed an issue with Undo/Redo not working with fixing columns. #6869
- Added a missing argument in the
deepObjectSizefunction. #6821 - Fixed an issue where the table threw errors while clicking the cells if the Handsontable was
initialized with
fixedRowsTopandfixedRowsBottomhigher than rows length. #6718 - Fixed an issue where it was not possible to change the state of checkbox-type, non-adjacent cells
using
SPACE. #4882 - Fixed an issue where resizing made rows shorter than expected and caused row misalignment. #6429
- Fixed an issue where Handsontable was missing rows when
preventOverflowwithupdateSettingswere used. #4303 - Adding properties which were not defined on initialization or by
updateSettingsto the source data is possible only by the usage ofsetSourceDataAtCell. #6664.