Why formulas don't work

Tags: #<Tag:0x00007f8b1dbcedf0>
#1

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

#2

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.

#3

thanks,when u update,notice me first.

#4

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/

#5

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.

#6

Hi @275704806

I’m more than happy to announce that this issue is fixed in the latest version - 12.2.0.

Here https://handsontable.com/docs/react-data-grid/release-notes/#_12-2 you can read more about the changes in this version.

#7