minSpareRows in javascript

Tags: #<Tag:0x00007efc620febb8>
#1

Hi,
I need 10000 rows default for that I have used this minSpareRows:10000.
But when I click Enter button on last row again 10000 rows are getting created, here I don’t want to create new 10k rows instead it should be one row in the bottom.

#2

Hi @kunal

You can use

minRows: 10000,
minCols: 5,

but loading data has better performance. So you may create an empty array of arrays (for example)
like here https://jsfiddle.net/handsoncode/91hqvtea/

or you can use the createSpreadsheetData helper and then use the clear() method to remove the data https://jsfiddle.net/handsoncode/o2gbfh9e/

#3