Set default cell value on each new row

2 posts, 0 answers
  1. Erik
    Erik avatar
    5 posts
    Member since:
    Feb 2015

    Posted 26 Jul Link to this post

    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

  2. Boyan Dimitrov
    Boyan Dimitrov avatar
    1728 posts

    Posted 28 Jul Link to this post

    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.

    Boyan Dimitrov
    Telerik by Progress
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
Back to Top