8.0.0 release

[wojciechczerniak]

Description

Various tasks that we want to address before releasing v8.0.0.

• [x] handsontable/handsontable#5751 indexMappers without hiddenIndexes
• [x] handsontable/handsontable#6178 Extend indexMapper with hiddenCollection
• [x] handsontable/handsontable#6178 hiddenColumns plugin refactor to use IndexMapper
• [x] handsontable/handsontable#6204 Remove the connection between collapsibleColumns and hiddenColumns plugins
• [x] handsontable/handsontable#6177 hiddenRows plugin refactor to use IndexMapper
• [x] handsontable/techwrite#4 Update documentation and examples
• [x] remove beforeChangeResult as a function check and warning (Handsontable v0.12 was a very long time ago)
  • [ ] #4-PR Prepare migration guide for breaking changes
  • [x] #6541-PR Remove "experimental" tag from ganttChart, formulas and nestedRows
• [x] Deprecate IE support. Remove IE from the documentation.
  • [x] #6541-PR Deprecate observeChanges plugin. Add a console warning when the plugin is enabled.
  • [x] #6541-PR Deprecate ganttChart plugin. Add a console warning when the plugin is enabled.
• [x] Remove post-install warning about v7.0.0 MIT license change. handsontable/handsontable#6608
• [x] Update README.md logo and screenshot for HiDPI screens (Retina) handsontable/handsontable#6609
• [x] Add a warning messege for removed hooks:
  Plugin hook "modifyRow" was removed in Handsontable 8.0.0. Please consult release notes <link> to learn about the migration path handsontable/handsontable#6613
• [x] Update deps handsontable/handsontable#5159, handsontable/handsontable#6610
  • moment.js to 2.24.05674
  • pikaday to 1.18.0
  • numbro to 2.1.2 (check minified build handsontable/handsontable#5790)
• [x] handsontable/handsontable#6525 Remove helpers that cover IE8 or not needed anymore

After code freeze

• [ ] Check performance and compare with 7.x.x branch

Checklist

1. • [x] handsontable/handsontable#2685 columnSorting should work without observeChanges
2. • [x] handsontable/handsontable#3328 beforeColumnResize and beforeRowResize first argument is column width
3. • [x] handsontable/handsontable#3568 manualMoveRow don't work after loadData
4. • [x] handsontable/handsontable#3726 Cannot Navigate Past Hidden Column Using Keyboard if hot.updateSettings is Called in AfterSelection
5. • [x] handsontable/handsontable#3770 Rendering issue on column udpate with updateSettings
6. • [x] handsontable/handsontable#3809 CRUD operations should work with columnSorting and loadData
7. • [x] handsontable/handsontable#3914 & handsontable/handsontable#5133nestedRows should work with InsertRow, RemoveRow operations,
8. • [x] handsontable/handsontable#3924 сolumnSummary does not work with columnSorting and context menu
9. • [x] handsontable/handsontable#3937 Blank Rows in Middle of Grid [PRO]
10. • [x] handsontable/handsontable#3958 DataSource.countColumns returns invalid number of columns for nested objects.
11. • [x] handsontable/handsontable#3978 afterOnCellMouseDown returns coords (0,0) after click on the topleft corner
12. • [x] handsontable/handsontable#4121 hiddenColumns settings are reseted after updateSettings
13. • [x] handsontable/handsontable#4154 formulas not init with nestedRows
14. • [x] handsontable/handsontable#4176 Headers doesn’t export with exportToFile in the specific case
15. • [x] handsontable/handsontable#4181 using 'hiddenColumns' and 'stretchH' shows a unnecessary horizontal scrollbar when there is enough space
16. • [x] handsontable/handsontable#4204 Using loadData on an object data doesn't work
17. • [x] handsontable/handsontable#4233 Drag down: can't return back to the original cell
18. • [x] handsontable/handsontable#4360 When changing cell type, cell editor does not dynamically change
19. • [x] handsontable/handsontable#4370 If the last column is a hidden column and stretchH is enabled, last column is being displayed
20. • [x] handsontable/handsontable#4381 updateSettings performance is very low because of hiddenColumns
21. • [x] handsontable/handsontable#4441 Allow cancelling of autofill in the beforeAutofill hook
22. • [x] handsontable/handsontable#4442 Filtering is using wrong indexes
23. • [x] handsontable/handsontable#4470 Wrong value after column move
24. • [x] handsontable/handsontable#4480 updateSettings in afterColumnMove
25. • [x] handsontable/handsontable#4501 afterRowMove hook returns improper target parameter
26. • [x] handsontable/handsontable#4553 manualColumnFreeze should work without manualColumnMove
27. • [x] handsontable/handsontable#4567 recordTranslator shouldn't return null - need more test
28. • [x] handsontable/handsontable#4576 [0.27.0+] Data not render when use manualRowMove and minSpareRows
29. • [x] handsontable/handsontable#4601 manualColumnFreeze should work with columnSorting
30. • [x] handsontable/handsontable#4666 Manual column width doesn't follow column if we insert / remove column
31. • [x] handsontable/handsontable#4713 Row moving doesn't work with column sorting when PersistentState is enabled
32. • [x] handsontable/handsontable#4716 Collapse not working correctly when using custom cell rendrers
33. • [x] handsontable/handsontable#4793 Cell type cannot be changed via setCellMeta
34. • [x] handsontable/handsontable#4897 Improper selection after insert column/row when mergeCells is enabled.
35. • [x] handsontable/handsontable#4926 manualColumnMove doesn't work when data object is empty
36. • [x] handsontable/handsontable#4999 collapsibleColumns doesn't work with columnSorting
37. • [x] handsontable/handsontable#5000 Incorrect data is returned after undoing the remove column option
38. • [x] handsontable/handsontable#5065 Common rowsMapper for columnSorting manualRowMove and trimRows - nothing to test
39. • [x] handsontable/handsontable#5068 Refactor manualRowMove - nothing to test
40. • [x] handsontable/handsontable#5112 Global index mapper (EPIC, nothing to do here)
41. • [x] handsontable/handsontable#5159 Update deps
42. • [x] handsontable/handsontable#5173 problem with afterColumnMove
43. • [x] handsontable/handsontable#5178 manualRowMove should work with filters
44. • [x] handsontable/handsontable#5200 manualColumnMove doesn't modify the columns in updateSettings
45. • [x] handsontable/handsontable#5207 Persisted manualColumnMove not restored when using loadData()
46. • [x] handsontable/handsontable#5208 Filtering results in blank rows
47. • [x] handsontable/handsontable#5244 loadData() breaks column filters
48. • [x] handsontable/handsontable#5328 Update data doesn't work with collapsed/trimmed rows?
49. • [x] handsontable/handsontable#5369 Handsontable colHeaders gets NaN on loadData
50. • [x] handsontable/handsontable#5388 Add beforeSetCellMeta hook with an ability to cancel the changes
51. • [x] handsontable/handsontable#5571 hiddenColumns doesn't work with columnSorting
52. • [x] handsontable/handsontable#5591 The "manualColumnMove" operation affects the column order of data loaded by "loadData".
53. • [x] handsontable/handsontable#5598 [8.0.0.-rc1] manualColumnMove should work with hiddenColumns
54. • [x] handsontable/handsontable#5704 hiddenColumns option interferes with keyboard movement.
55. • [x] handsontable/handsontable#5707 Filter causes Minsparerows to have problems
56. • [x] handsontable/handsontable#5753 Nested rows bad state after changing data
57. • [x] handsontable/handsontable#5771 getSourceData functions return wrong data for nested rows
58. • [x] handsontable/handsontable#5792 Expand collapsed column, is expanding also 'child' collapsed columns, except the first child
59. • [x] handsontable/handsontable#5794 ColumnSummary: Extra row + unchangeable values
60. • [x] handsontable/handsontable#5817 Hiding first rows bug
61. • [x] handsontable/handsontable#5824 skipColumnOnPaste is broken with columnSorting enabled
62. • [x] handsontable/handsontable#5849 [2.0.0+] Scrolls to the end when columns are updated such that the selected column is removed
63. • [x] handsontable/handsontable#5860 trimRows should work with moveRow
64. • [x] handsontable/handsontable#5861 currentColClassName doesn't work properly with nestedHeaders
65. • [x] handsontable/handsontable#5862 trimRows does not work with minSpareRows
66. • [x] handsontable/handsontable#5871 Hiding columns affect selection of hidden columns
67. • [x] handsontable/handsontable#5874 nestedRows does not allow to keep rowHeaders after collapsing
68. • [x] handsontable/handsontable#5875 collapsibleColumns should work without hiddenColumns
69. • [x] handsontable/handsontable#5877 hiddenColumns doesn't work properly with autoWrapRow/autoWrapCol
70. • [x] handsontable/handsontable#5881 When we hide first column on IE we get double border for top left corner
71. • [x] handsontable/handsontable#5882 Indexes of nestedHeaders are not recalculating after remove/add column
72. • [x] handsontable/handsontable#5883 hiddenColumns plugin unsets cell's renderer
73. • [x] handsontable/handsontable#5889 nestedRows should work with filters
74. • [x] handsontable/handsontable#5890 filters should work with columnSorting
75. • [x] handsontable/handsontable#5900 Wrong position of buttons in nestedRows after use detach from parent
76. • [x] handsontable/handsontable#5906 Selection of a whole row does not happen consequently after selecting a row header.
77. • [x] handsontable/handsontable#5909 hiddenColumns stores visual indexes, should use physical
78. • [x] handsontable/handsontable#5915 trimRows should work with filters
79. • [x] handsontable/handsontable#5931 manualColumnMove doesn't work when columns count is different from array of objects properties count
80. • [x] handsontable/handsontable#5953 trimRows should work with startRows
81. • [x] handsontable/handsontable#5956 columnSorting is not working correctly with loadData
82. • [x] handsontable/handsontable#5999 handsontable 7.0.2 context menu issue with multiple selected rows in case of 1st column hidden
83. • [x] handsontable/handsontable#6005 afterColumnMove/beforeColumnMove doesn't tell you where the columns move to
84. • [x] handsontable/handsontable#6035 The function loadManualRowHeights is return a array, but in the typescript .d.ts file it is defined as void
85. • [x] handsontable/handsontable#6051 Wrong cell meta removed when deleting rows
86. • [x] handsontable/handsontable#6058 getSourceData functions return wrong data for nestedRows
87. • [x] handsontable/handsontable#6066 move multiple rows with nestedRows
88. • [x] handsontable/handsontable#6086 Once we enable columnSorting we cannot run the merge() method
89. • [x] handsontable/handsontable#6088 Duplicated rows while using manualRowMove with improper index
90. • [x] handsontable/handsontable#6113 We can show columns/row when they're all hidden
91. • [x] handsontable/handsontable#6186 Bug with scrollbar and dimension calculation in Firefox
92. • [x] handsontable/handsontable#6193 Add hooks to collapsibleColumns plugin
93. • [x] handsontable/handsontable#6167 JSON data with empty value will lose some double quotes when pasted into a cell
94. • [x] handsontable/handsontable#6177 Adjust HiddenRows to new IndexMapper architecture
95. • [x] handsontable/handsontable#6181 Row selection ignores columns that are hidden at the end
96. • [x] handsontable/handsontable#6204 CollapsibleColumns should no longer use HiddenColumns plugin
97. • [x] handsontable/handsontable#6218 When we again on the same cell with RMB we get a browser menu
98. • [x] handsontable/handsontable#6224 Can't hide rows and merge cells at the same time
99. • [x] handsontable/handsontable#6278 Filters and minSpareRows problems at the same time - additional error fixed
100. • [x] handsontable/handsontable#6295 updateSettings can not update tableClassName
101. • [x] handsontable/handsontable#6300 doesn't work with columnSummary when plugin tries to create a row
102. • [x] handsontable/handsontable#6309 Set data at physical row instead of visual. setSourceDataAtCell was added
103. • [x] handsontable/handsontable#6310 Visual indexes are wrong when using trimRows and columnSorting
104. • [x] handsontable/handsontable#6332 Lost readonly property if I ask confirm in beforeRemoveCol or beforeRemoverow
105. • [x] handsontable/handsontable#6334 Inconsistent selection using the right mouse button for first row/column
106. • [x] handsontable/handsontable#6346 Missing typings for instance.undoRedo
107. • [x] handsontable/handsontable#6347 Typing mismatch for Handsontable.plugins.ContextMenu
108. • [x] handsontable/handsontable#6355 We're not able to move column when all columns are selected by ctrl + a
109. • [x] handsontable/handsontable#6363 minSpareCols with undo adds too many columns
110. • [x] handsontable/handsontable#6371 Some classes for table are missing if one of them is empty
111. • [x] handsontable/handsontable#6376 Hiding rows while there is a merged area involved causes data shifting and
112. • [x] handsontable/handsontable#6381walkontable.css and handsontable.css stylesheets are not in sync
113. • [x] handsontable/handsontable#6386 Wrong selection area after sorting with hidden rows
114. • [x] handsontable/handsontable#6412 After removing column rowHeaders stay improperly
115. • [x] handsontable/handsontable#6413 colHeaders order is not updated after manual move with empty object data source
116. • [x] handsontable/handsontable#6426 When we define data with more data than used in columns we cannot show column once it's hidden
117. • [x] handsontable/handsontable#6430 The afterRowResize hook shares unbelievable results in the 2nd parameter
118. • [x] handsontable/handsontable#6432 Can't detach from parent
119. • [x] handsontable/handsontable#6433 Undoing removing nested row doesn't work
120. • [x] handsontable/handsontable#6435 Manual row resize handler throws an error when bottom rows overlay is enabled
121. • [x] handsontable/handsontable#6463 colHeader is truncated after moving hiddenColumn
122. • [x] handsontable/handsontable#6477 customBorders plugin is missing in the definition file
123. • [x] handsontable/handsontable#6514 PreventOverflow feature doesn't work if multiColumnSorting plugin is enabled
124. • [x] handsontable/handsontable#6539 beforeRowMove args have wrong types
125. • [x] handsontable/handsontable#6548 getByRange for sourceData doesn't work properly with nested object data.
126. • [x] handsontable/handsontable#6557 Hidden (last) column is visible upon resizing Columns
127. • [x] handsontable/handsontable#6559 readOnly for column is erased (does not apply) if we use filters
128. • [x] handsontable/handsontable#6575 Old CSS classes are not removed after updateSettings
129. • [x] handsontable/handsontable#6595 [8.0.0] Hidden Indexes refactor
130. • [x] handsontable/handsontable#6600 We're not able to align cells if the selection is made upward
131. • [x] handsontable/handsontable#6664 Add modifySourceData hook and setSourceDataAtRowProp, setSourceDataAtCell methods
132. • [x] handsontable/handsontable#6668 Column hiding issue after columns moved manually
133. • [x] handsontable/handsontable#6670 Headers are deselected after undoing removing
134. • [x] handsontable/handsontable#6672 Remove debug key (key, css, docs)
135. • [x] handsontable/handsontable#6695 columnSummary, Filters and spare rows are causing 'RangeError: Maximum call stack size exceeded'
136. • [x] handsontable/handsontable#6699 [5.0.2] EDGE Dropdown menu onMouseOut event causes critical errors when hovering over vertical scrollbar
137. • [x] handsontable/handsontable#6703 The cell meta is being retrieved using the wrong coordinates
138. • [x] handsontable/handsontable#6755 Double click on the column resize handle does not adjust size correctly
139. • [x] handsontable/handsontable#6756 After enabling false to beforeAutofill we should add an additional test.
140. • [x] handsontable/handsontable#6770 Selection skips the highest parent
141. • [x] handsontable/handsontable#6792 Remove old warning
142. • [x] handsontable/handsontable#6831 Incorrect selection after hiding first row
143. • [x] handsontable/handsontable#6840 Wrong union type for startPosition
144. • [x] handsontable/handsontable#6842 Backspace in filter by value option does not work initially
145. • [x] handsontable/handsontable#6843 Calling updateSettings changes the index of frozen columns via freezeColumn method
146. • [x] handsontable/handsontable#6881 Bug: Nested headers and hidden columns highlight the next column
147. • [x] handsontable/handsontable#6888 The wrong data in merge cells after the hidden column and additionally an error occurs.
148. • [x] handsontable/handsontable#6904 trimRows and hiddenRows with certain settings break borders
149. • [x] handsontable/handsontable#6928 nestedRows blocks table from loading if data is not provided
150. • [x] handsontable/handsontable#6965 After moving row from bottom to top the row indexes changes if the first row is hiding.
151. • [x] handsontable/handsontable#6973 Keyboard navigation with selection does not work on merged cells
152. • [x] handsontable/handsontable#6974 It’s possible to select hidden column/row.
153. • [x] handsontable/handsontable#6975 Cannot selectAll when the first row is hidden
154. • [x] handsontable/handsontable#6976 Hiding first row causes column headers selection to lack blue highlight
155. • [x] handsontable/handsontable#6977 Hiding first row causes 2nd row to lack a top border
156. • [x] handsontable/handsontable#6978 Incorrect column header highlight when merged cells are unmerged and hiddenColumns are used
157. • [x] handsontable/handsontable#6982 [7.0.0] The editor is moved by 1px when the first row / column is hidden
158. • [x] handsontable/handsontable#6990 ReadOnly state for some cells is lost when we remove rows with trimRows turned on
159. • [x] handsontable/dev-handsontable#376 Undoing column removal causes column headers to lack a header
160. • [x] handsontable/handsontable#7005 We cannot set focus to a column to open context menu after applying a filter
161. • [x] handsontable/handsontable#7020 mergedCells with hidden causes issues with rendering
162. • [x] handsontable/handsontable#7022 Remove GanttChart plugin
163. • [x] handsontable/handsontable#7023 Deprecate HeaderTooltips plugin
164. • [x] handsontable/handsontable#7028 [1.18.0] Too many layers of highlight with noncontinuous selection on merged cells
165. • [x] handsontable/handsontable#7035 NestedHeaders does not allow to define header level as an empty array
166. • [x] handsontable/handsontable#7036 Passing nestedHeaders as a single empty array stops the table from painting
167. • [x] handsontable/handsontable#7043 When we copy and paste a header we get a new empty row when data is hidden
168. • [x] handsontable/handsontable#7045 afterSelectionEnd returns incorrect data when clicking on a column when we have all the rows hidden
169. • [x] handsontable/handsontable#7050 Opening a context menu for a column when its hidden data is selected does not block adding of rows via menu
170. • [x] handsontable/handsontable#7061 Problems with adding rows from the corner when all rows are trimmed
171. • [x] handsontable/handsontable#7074 The row/column resize hooks should not return null.
172. • [x] handsontable/handsontable#7076 [2.0.0] Loss of selection after merging from headers
173. • [x] handsontable/handsontable#7095 We are not able to unmerge cells if part of it is hidden
174. • [x] handsontable/handsontable#7097 Clear() method does not work for hidden data
175. • [x] handsontable/handsontable#7099 calling clear() method removes the focus from the table
176. • [x] handsontable/handsontable#7114 Using read-only and alignment from the context menu when all columns are selected is disabled
177. • [x] handsontable/handsontable#6232 trimWhitespace=false and wordWrapping
178. • [x] handsontable/handsontable#7103 Additional, native for macOS editor selection in Firefox 78
179. • [x] handsontable/handsontable#6955 Safari draws different borders than Chrome and FF, when editor is opened
180. • [x] handsontable/handsontable#6788 "Hide" property missing in CustomBorders typings
181. • [x] handsontable/handsontable#6869 Undo: Add support for fixing columns
182. • [x] handsontable/handsontable#6149 Rows cannot be resized to less than rowHeights

TODO

• [ ] handsontable/handsontable#7031 Methods colToProp and propToCol should work properly
• [x] https://github.com/handsontable/angular-handsontable/issues/197 Update Angular wrapper to support v8
• [x] https://github.com/handsontable/vue-handsontable-official/issues/165 Update Vue wrapper to support v8
• [x] https://github.com/handsontable/react-handsontable/issues/189 Update React wrapper to support v8

Issues that will NOT be fixed by v8

• ~#4631 Broken height header when use column height and hidden column setting~
• ~#3919 nestedRows should work with ColumnSorting~
• ~#5525 afterRemoveRow, afterInserRow, afterRemoveCol, afterInsertCol are called before cellMeta is updated~
• ~#5856nestedRows should work with moveRow~
• ~#6905 We cannot auto fill using db-click if hiddenRows is used~
• ~#6001 Freezing columns do not work with nestedHeaders~
• ~#5125 AutoFill not works will there is a mergedCell in the target area~
• ~#6794 When nestedHeaders are enabled wrong column is removed~
• ~#6787 nestedHeaders blocks rendering of rows if the first row exceeds the viewport~
• ~#6669 Undoing removing hidden rows makes rows exposed~
• ~#5543 Error after update settings rendering twice and picking wrong renderer functions~
• ~#6004 ManualColumnMove dragging breaks after updateSettings()~
• ~#6934 Trimming rows causes the newly added rows by paste to remain~
• ~#6327 Inconsistency with context menu 'Remove columns' option~
• ~#1501 Sorting passing logical index through afterChange event~
• ~#6728 Copy doesn't work when selected hidden column~
• ~#6742 Paste off-by-one after show/hide column~
• ~#6743 Too many values pasted when column is hidden~
• ~#6833 skipColumnOnPaste and skipRowOnPaste when added to table settings hang the browser down after pasting~
• ~#5961 Additional row added during copy/paste operations and with hidden rows/columns enabled~
• ~#6395 Some headers are gone if we hide and show them again~
• ~#6397 Sorting indicator moves incorrectly when adding a column~
• ~#6518 [8.0.0] Moving data isn't working properly, when there are skipped indexes~
• ~#6067 [7.1.0.+] We cannot move nested row to become the last one in the table (related to handsontable/dev-handsontable#165 ?)~
• ~#7062 Idea of highlighting trimmed headers with blue color (active header)~
• ~#6832 Second column selection is misaligned 2 px right~
• ~#6960 When there's only one row of data clicking on a header shortens selection by 1px~

[wojciechczerniak]

New screenshot https://github.com/krzysztofspilka/handsontable/blob/master/handsontable-github-preview.png

New logo https://github.com/krzysztofspilka/handsontable/blob/master/handsontable-logo.svg

Upload to master.

[AMBudnik]

@wojciechczerniak handsontable/handsontable#5792 is described as

Issues that may be fixed by handsontable/handsontable#6204

but it is already fixed by this PR handsontable/handsontable#6716 (demo posted handsontable/handsontable#5792)
It is the same for handsontable/handsontable#6770 solved in 8.0.0.-beta2-rev2

[wojciechczerniak]

List merged with https://github.com/handsontable/handsontable/issues/6465#issue-522391935

[AMBudnik]

Epic closed with the release of v8.0.0