Hi,
I am feeding data to handsontable through JSON object which actually holds formulas. After doing some modifications I am getting back the data from grid using getSourceData()
method and storing it to another variable, where actually I need the values calculated by the formulas and some-other cells which are modified. I am getting values from other cells but not from the cells where formulas are. So what I did is I have retrieved the values using getDataAtCol()
method and got the value from the columns I need (i.e. columns where values calculated by the formulas). After that I changed the JSON values in the duplicate variable(i.e. I replaced the formulas with the values Using a loop), here the issue begins, Once I change the duplicate variable its even getting updated in original JSON, so that my formulas are not working.
I am not sure whether the issue is from my side or yours. If it is from my side then guide me how to fix it, or if it’s from your end consider it as bug and please fix it. I had attached my github repository link of my demo, Please review and update me.
Thanks,
Bala