-> How do i insert a new row above/below and merge it with the existing merged row
example. I have tried to insert a new row in second position but i want to merge it with existing Register. How do i Do it
Insert row above and merge cells
The operation depends on the index of the selected cell when we perform the action. Could you please point me out here https://jsfiddle.net/49wjyapu/3/ which cell do you select when you are opening the menu to use Add row below option?
i m trying click on cell E2 and select insert row above option
it should merge with the existing B2 merged cells
So if you plan to
- click on any cell in the second row and get a merged area to extend for
Add row above - click on any cell in the fourth row and get a merged area to extend for
Add row below
you would need to create a custom context menu option that detects of the index of a selected cell contains a merged area.
Useful resources
- custom context menu example http://jsfiddle.net/43h2fznx/
-
alter()method to add a new row https://handsontable.com/docs/api/core/#alter -
mergeCellssyntax https://handsontable.com/docs/merge-cells/#overview and theupdateSettings()method to reapply to merged area https://handsontable.com/docs/api/core/#updatesettings
thank you
I’m glad I could help.