[GH #6359] Why formulas don't work

Tags: #<Tag:0x00007fd2cd077310> #<Tag:0x00007fd2cd077180>

https://jsfiddle.net/8w673gk4/1/
when i del
{“row”: 15, “col”: 2, “rowspan”: 1, “colspan”: 10}
it work .
but when i add this ,formula don’t work

Hi @275704806

this issue is associated to use of mergeCells with Formulas. This issue has been raised and investigated in this topic https://github.com/handsontable/handsontable/issues/6359

I will update you as soon as we get any news on that subject.

thanks,when u update,notice me first.

this issus can be solve by add code
afterChange:function (changes,source){
if(source!==‘loadData’&&source!==‘populateFromArray’&&source!==‘userchange’)
{
this.setDataAtCell(15,12,’=sum(M4:M15)’,‘userchange’);
this.setDataAtCell(14,11,’=sum(L4:L14)’,‘userchange’);
}
},

https://jsfiddle.net/xdnrmz23/

Thank you for sharing the investigation results. I’m glad that you’ve found a cleaver way to get this done before we’ll be able to publish an official fix.