Customize dialogs

Customize dialogs

Posted by: peter on 4 September 2025, 8:17 pm EST

• 

  peter

  • Post Options:
  • Link
    Copy

  Posted 4 September 2025, 8:17 pm EST

  i would like to customize some dialogs like

  “SpreadJS Designer” when trying to edit a protected sheet.

  I’m using React. Is it possible?

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 8 September 2025, 3:34 am EST

  Hi Peter,

  As we understand, you are required to modify the protection error message when trying to edit the protected sheet. Please refer to the code snippet below that edits the protection message when a protected sheet is edited:

  spreadRef.spread.bind(GC.Spread.Sheets.Events.InvalidOperation, function (sender, args) {
      if (args.invalidType === GC.Spread.Sheets.InvalidOperationType.editProtected) {
          args.message = customProtectionErrorMessage;
      }
  });

  You can further refer to the attached code sample that uses the above code snippet and edits the protection error message (see below).

  Please let us know if you require any further assistance.

  Kind Regards,
  
  Chirag Gupta

  Attachment: https://jscodemine.mescius.io/share/GAFQ8rp7mkCj51NUtP0JOg

  References:

  1. InvalidOperation: https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Sheets.Events#invalidoperation
  2. InvalidOperationType.editProtected: https://developer.mescius.com/spreadjs/api/enums/GC.Spread.Sheets.InvalidOperationType#editprotected