Prevent sheet from being deleted

Prevent sheet from being deleted

Posted by: ltetemadze on 17 June 2020, 6:19 am EST

• 

  ltetemadze

  • Post Options:
  • Link
    Copy

  Posted 17 June 2020, 6:19 am EST

  Hello,

  I could not find it, is it possible to protect the sheet from being deleted (renamed, etc.)?

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 18 June 2020, 9:23 am EST

  Hi,

  SJS provides SheetChanging, SheetNameChanging, SheetMoving Events that could be used for preventing the changes in sheet for example:

  For preventing the name changing action on the sheet you may use SheetNameChanging Events please refer to the following code snippet.

  spread.bind(GC.Spread.Sheets.Events.SheetNameChanging, (e, args) => {
      args.cancel = true;
    });
  

  Similarly, for preventing the delete Action on the sheet you may use sheetChanging events and cancel the event if the action is deleteSheet or you could protect the sheet that will also disable the delete action on the sheet. Please refer to the following code snippet:

  spread.bind(GC.Spread.Sheets.Events.SheetChanging, (e, args) => {
      if (args.propertyName === "deleteSheet") {
        args.cancel = true;
      }
    });
  

  You may also refer to the following sample which demonstrates the same:
  
  https://codesandbox.io/s/hungry-swirles-41wze?file=/src/index.js

  API References:

  • SheetChanging: https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Events~SheetChanging_EV.html

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

  • SheetMoving: https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Events~SheetMoving_EV.html

  Regards