Alternative of setDataAtCell

Tags: #<Tag:0x00007efc708b1ff0>
#1

when im using this functoon hot1.setDataAtCell() im getting performance issue

i want alternative function…

#2

Hi @kunal

This method is only slow if you have a large dataset or are using heavy logic on data change.

I would need to know your settings to propose some other solutions.

#3

i want text of the length in that function creating new column and updating length.
hot1.alter(‘insert_col’,parseInt(colIndex)+1,1);
var columnData = hot1.getDataAtCol(colIndex);
for (var i = 0; i < columnData.length; i++){
if(!columnData[i]){
}else{
hot1.setDataAtCell(i,parseInt(colIndex)+1,columnData[i].length);
}
}

this is small function… i 1k data operation good but 10k data it takes 5 min
what can i do

#4

If you are running the setDataAtCell method 1000 times in the run I recommend changing the source data and use loadData() afterwards.It will result in 1 call to Handsontable instead of 1000.

#5

please show me example

#6

I do not have a that example in our demo database. But if you could confirm your Support and Maintenance plan status I will be able to create the following demo especially for you.

Please share this forum link and your licenseID on support@handsontable.com to proceed.

#7

i shared
please check

#8