Events for listening Sheet name change

Events for listening Sheet name change

Posted by: davide.vago on 13 March 2020, 12:12 pm EST

• 

  davide.vago

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 13 March 2020, 12:12 pm EST

  Good morning/afternoon.

  I’m currently trying to catch the user’s action of changing name across a list of existing sheets however looking through the documentation it seems like there are just 2 available Events regarding the WorkSheet:

  ActiveSheetChanging
  
  ActiveSheetChanged

  Do you have any suggestion and solution for my requirement?
  
  Thanks for your support.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 16 March 2020, 4:48 am EST

  Hi Davide,

  You could use SheetNameChanged or SheetNameChanging Event for observing the changes in sheet names. Please refer to the following code snippet:

  spread.bind(GC.Spread.Sheets.Events.SheetNameChanged, function (sender, args) {
     console.log(args.oldValue);
  });
  

  API references:
  
  • SheetNameChanged Event: https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Events~SheetNameChanged_EV.html
  
  • SheetNameChanging Event: https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Events~SheetNameChanging_EV.html

  ~sharad