handsontable/handsontable 8.0.0-beta.2 on GitHub

We are excited to announce we have just released the second beta version of 8.0.0. This blog post describes changes that happened after the release of the first beta, for the previous changes please see the previous blog post.

After implementing a new architecture for managing row and column indexes several parts of the library had te be adapted. It mainly includes adjusting the existing hooks to work properly with the new solution for managing the indexes. This is the last step before releasing a stable 8.0.0 version.

Major changes

We adapted the library to work with the new architecture for row and column management.

Breaking changes

Changes related to the refactor of HiddenColumns and CollapsibleColumns. They will be compatible with upcoming IndexMappers #6547 along with other adjustments #6178:
- Hidden indexes will no longer be rendered, as a consequence afterRenderer, modifyColWidth, beforeStretchingColumnWidth will be executable only on visible (meaning, rendered) rows and columns.
- The getColWidth for 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 modifyColWidth hook will not be called internally. However, it will be executed when the user will call the getColWidth.
- Hidden indexes aren't rendered. As a consequence hooks beforeValueRender, beforeRenderer, afterRenderer, modifyColWidth, beforeStretchingColumnWidth etc. will be executed just for some of the columns (just the rendered ones).
- listen function from the core API used to accept modifyDocumentFocus as optional parameter, this parameter was removed.
- CustomBorders plugin was adapted to work with HiddenColumns properly, 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. #7083.
- CollapsibleColumns will no longer use HiddenColumns plugin to work. #6204
- Refactored HiddenColumns to be compatible with upcoming IndexMappers. #6179
- Renamed the following methods of the IndexMapper:
  - from getPhysicalIndex to getPhysicalFromVisualIndex
  - from getVisualIndex to getVisualFromPhysicalIndex
  - from isSkipped to isTrimmed
  - from getNotSkippedIndexes to getNotTrimmedIndexes
  - from getNotSkippedIndexesLength to getNotTrimmedIndexesLength
  - from SkipMap to TrimmingMap
  - from VisualIndexToPhysicalIndexMap to IndexesSequence.
- hiddenRow and hiddenColumn hooks were removed. They were used to check if a given index is hidden in the HiddenColumns and HiddenRows plugins. Since now there may be more sources of hiding indexes they have been replaced by IndexMapper with the new isHidden method. It keeps the broad information about hidden indexes and their sources.
- rowOffset and colOffset were removed since they aliased the methods from Walkontable #6547
Changes related to adjusting HiddenRows to new IndexMapper architecture #6177:
- Adjusted HiddenRows to new IndexMapper architecture.
- Refactored the HiddenRows plugin. #6887
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. #6949
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.
NestedHeaders plugin 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.
Added modifySourceData hook and setSourceDataAtRowProp, setSourceDataAtCell methods. #6664
The right mouse button (RMB) click on the corner when there is no data will show all options disabled. This has two exceptions though: Insert column right and Insert row below when a table has data type defined by dataSchema as array, except Insert row right otherwise.
Left mouse button (LMB) click on the top left corner will now select all cells along with their headers.
Removed the experimental GanttChart plugin #7022

Depraciations

HeaderTooltips plugin becomes deprecated and will be removed in the next major version. #7023
Internet Explorer support is deprecated and will be removed by the end of the year #7026

Changelog

Added

Added modifySourceData hook and setSourceDataAtRowProp, setSourceDataAtCell methods. #6664.
Added an extra type of index map has been introduced. It's HidingMap. It works similar to the TrimmingMap. #6547
Added new methods to the IndexMapper class #6547:
- getPhysicalFromRenderableIndex: (renderableIndex: number) => number | null,
- getVisualFromRenderableIndex: (renderableIndex: number) => number | null,
- getRenderableFromVisualIndex: (visualIndex: number) => number | null,
- isHidden: (physicalIndex: number) => boolean,
- getFirstNotHiddenIndex: (fromVisualIndex: number, incrementBy: number, searchAlsoOtherWayAround?: boolean, indexForNextSearch?: number) => number | null,
- getNotHiddenIndexes: (readFromCache?: boolean) => number[],
- getNotHiddenIndexesLength: () => number,
- getRenderableIndexes: (readFromCache?: boolean) => number[],
- getRenderableIndexesLength: () => number.
Added new argument to scrollViewportTo method: optional considerHiddenIndexes which is a boolean. #6547
Added additional information available in the cell meta object - the language. #6254.
Added a possibility to allow cancelling of autofill in the beforeAutofill hook #4441
Added support for newer versions of moment, numbro and pikaday. #5159
Added afterAutoFill hook. #6135
Added z-index to fixedRowsBottom. #6269
Added deprecated warning messages mechanism for plugin hooks. #6613
Added a missing argument in the deepObjectSize function. #6821
Added missing types for instance.undoRedo. #6346
Added countRenderableColumns method to the TableView #6887
Added missing "hide" property in CustomBorders typings. #6788
Added beforeSetCellMeta hook with an ability to cancel the changes. #5388
Added additional test for autofill plugin. #6756

Changed

Refactored hidden indexes. #6595
Click on a row header will select all cells (also hidden). #2391
Extracted Cell-Meta logic from Core to separate module. #6254
The CellMeta manager 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
The right mouse button (RMB) click on the corner when there is no data will show all options disabled. This has two exceptions though: Insert column right and Insert row below when a table has data type defined by dataSchema as array, except Insert row right otherwise. #6547
Hidden indexes will no longer be rendered, as a consequence afterRenderer, modifyColWidth, beforeStretchingColumnWidth will be executable only on visible (meaning, rendered) rows and columns. #6547
The getColWidth for 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. #6547
Left mouse button (LMB) click on the top left corner will now select all cells. #6547
The modifyColWidth hook isn't called internally. However, it will be executed when the user will call the getColWidth. #6547
IndexMapper getPhysicalIndex method was renamed to getPhysicalFromVisualIndex.#6547
IndexMapper getVisualIndex method was renamed to getVisualFromPhysicalIndex.#6547
IndexMapper isSkipped method was renamed to isTrimmed.#6547
IndexMapper getNotSkippedIndexes method was renamed to getNotTrimmedIndexes.#6547
IndexMapper getNotSkippedIndexesLength method was renamed to getNotTrimmedIndexesLength.#6547
SkipMap class was renamed to TrimmingMap.#6547
VisualIndexToPhysicalIndexMap class was renamed to IndexesSequence.#6547
Hidden indexes aren't rendered. As a consequence hooks beforeValueRender, beforeRenderer, afterRenderer, modifyColWidth, beforeStretchingColumnWidth etc. will be executed just for some of the columns (just the rendered 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.
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
NestedHeaders plugin 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
CustomBorders plugin was adapted to work with HiddenColumns properly, 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. #7083
CollapsibleColumns will no longer use HiddenColumns plugin to work. #6204

Deprecated

HeaderTooltips plugin 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

Removed helpers that covered IE8 support or are not needed anymore. #6525
Removed old unnecessary warning about beforeChange callback. #6792
Removed debug key (key, css, docs). #6672
Removed hiddenRow and hiddenColumn hooks. #6547
Removed optional argument modifyDocumentFocus from the listen function.
Removed rowOffset and colOffset public API methods since they aliased the methods from Walkontable #6547
Removed the experimental GanttChart plugin #7022
Removed post-install warning from package.json file #6608

Fixed

Fixed an issue where Hidden columns become visible when the user ran updateSettings. #4121
Fixed an issue where using hiddenColumns and stretchH showed a redundant horizontal scrollbar. #4181
Fixed an issue in which if the last column was a hidden column and stretchH was enabled, the last column was displayed. #4370
Fixed an issue where updateSettings performance was very low because of hiddenColumns being 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 nestedHeaders plugin. #4716
Fixed an issue where hiddenColumns did not work properly with columnSorting. #5571
Fixed an issue where manualColumnMove should work with hiddenColumns. #5598
Fixed an issue where hiddenColumns option 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 collapsibleColumns were set to true it was impossible to exit selection mode. #5875
Fixed an issue where hiddenColumns did 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 nestedHeaders duplicated a header name if more columns are added. #5882
Fixed an issue where hiddenColumns plugin unset cell's renderer. #5883
Fixed an issue where hiddenColumns had stored visual indexes and should have used physical indexes. #5909
Fixed an issue where the additional row was added during copy/paste operations and with hidden rows/columns enabled. #5961
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 columns caused 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 some headers were gone when hidden and shown again. #6395
Fixed an issue where colHeader was truncated after moving hiddenColumn. #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 copy-and-paste worked wrong in a cell that was hidden and then uncovered again. #6742
Fixed an issue where too many values were pasted when the column was hidden. #6743
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 columnSorting to true (on initialization or via updateSettings) made headers non-collapsible programmatically via collapseAll method. #4999
Fixed an issue where customBorders plugin was missing in the definition file. #6477
Fixed incorrect size of wtHiderand wtHolder in overlays. #3873
Fixed an issue where updateSettings could not update tableClassName. #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 minSpareCols with undo added 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 readOnly for column was erased (did not apply) if filters were used. #6559
Fixed an issue where readonly property was lost after declining confirmation in beforeRemoveCol or beforeRemoverow. #6332
Fixed an issue where readOnly state for some cells was lost when rows with trimRows turned on were removed. #6990
Fixed incorrect column header highlight when merged cells were unmerged and hiddenColumns were 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 selectAll when 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 nestedRows blocked 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 trimRows and hiddenRows with specific settings broke borders. #6904
Fixed wrong union type for startPosition. #6840
Fixed type mismatch for Handsontable.plugins.ContextMenu. #6347
Fixed an issue where manualColumnMove did not modify the columns in updateSettings. #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 currentColClassName did not work properly with nestedHeaders. #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 getSourceData functions returned wrong data for nested rows. #5771
Fixed na issue where formulas plugin did not work with nestedRows. #4154
Fixed an issue where nested headers and hidden columns highlighted ad additional column when used together. #6881
Fixed an issue where getByRange for 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 mergedCells with 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 onMouseOut event 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 NestedHeaders did not allow to define header level as an empty array. #7035
Fixed an issue where passing nestedHeaders as 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 exportToFile in 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 afterRowResize hook 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 updateSettings changed the index of frozen columns via freezeColumn method. #6843
Fixed an issue where deleting the last column via updateSettings which 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 clear method removed the focus from the table. #7099
Fixed an issue where clear method 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 beforeRowMove arguments. #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.