Events on new row/column

Events on new row/column

Posted by: davide.vago on 15 July 2019, 11:12 pm EST

• 

  davide.vago

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 15 July 2019, 11:12 pm EST

  Good morning/afternoon.

  I’m currently working on a spreadsheet instance which contains an injected table data and has on SelectionChanged a map to the table data.

  I’m facing an issue whenever the user creates a new row/column the map on SelectionChanged remains linked to the col/row numbers

  Reading across the multiple documentations of SpreadJS I can’t find any event triggered when the user creates a new row/column which could be essential to modify the indexes of the table data.

  Does SpreadJS have some listener for the above operations (add row/col)?
  
  Thanks in advance for your support.

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 16 July 2019, 10:52 pm EST

  Hello David,
  
  Please try to bind the RowChanged event. Pleas refer to the following code snippet:

  spread.bind(GC.Spread.Sheets.Events.RowChanged,function(e,args){
                  var row=args.row;
                  var sheet=args.sheet;
              })
  

  It should work for you.

  Regards,
  
  Manish Gupta

• 

  davide.vago

  • Post Options:
  • Link
    Copy

  Posted 17 July 2019, 1:05 am EST

  Thanks, this does the job.