Insert row above and merge cells

anshuman.singh · February 9, 2022, 1:01pm

→ 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

aleksandra_budnik · February 9, 2022, 1:17pm

Hi @anshuman.singh

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?

anshuman.singh · February 9, 2022, 1:27pm

i m trying click on cell E2 and select insert row above option
it should merge with the existing B2 merged cells

aleksandra_budnik · February 9, 2022, 1:50pm

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 Handsontable example - JSFiddle - Code Playground
alter() method to add a new row Core API reference - JavaScript Data Grid | Handsontable
mergeCells syntax Merge cells - JavaScript Data Grid | Handsontable and the updateSettings() method to reapply to merged area Core API reference - JavaScript Data Grid | Handsontable

anshuman.singh · February 10, 2022, 4:34am

thank you

aleksandra_budnik · February 10, 2022, 7:18am

I’m glad I could help.