Revert back Merged cells after Sorted

Tags: #<Tag:0x00007f8b1d30af20>
#1

Hi,
I am using merge function to automatically merge cells. However when the table is sorted the merge disappear but the cells remain empty value. Is there a way so that the cells will be filled with the merged cell data when sorted and unmerged?

#2

Hey @shajibaig

Can you share a draft with input /output data? I fought it difficult to image how this should look.

#3

Check this fiddle:

https://jsfiddle.net/rahulbaruah/1mkbLszp/44/

Try to unmerge or column sort. I want the cells A5& A6 to be filled by the A4 data after unmerge.

#4

Thank you. I can see what’s going on here. I’ll check if there’s anything we can do to fix it without adding commits.

#5

Thanks! kindly check.

#6

I can see that Excel also erases the values and even displays a window that this data is gone.

but in Handsontable it doesn;t have to be gone (as we have callbacks) and the setDataAtCell method that you can use in the afterMergeCells hook. afterMergeCells will let you know what cell have been changed and how.

#7

Thanks for the reply. I will create a workaround for my problem.

#8