Set default cell value on each new row

[Erik]

hi guys, 

I'm trying to set a default value for all the cells of a specific index whenever a new row in created in the spreadsheet. 

I wanted to do this with the change event of the spreadsheet and basically do: get current selected cell position & go to my desired index on that row and add the default value. However i wasn't able to find how to get the selected's cell position in the change event function.

Another idea was to set a default value for my specific cell index with "sheets.rows.cells.value" but i see it needs a row index which in my case is dynamic.

 

Thanks a lot for the help

[Boyan Dimitrov]

Hello Erik,

Indeed in the change event there is no information about the row and cell of the inserted row. 

A possible solution would be to find the range for a specific cell and set its value. Please refer to the example below insertRow article.

Regards,
Boyan Dimitrov
Telerik by Progress