Allow setColumnResizable and setrowResizable on Locked Sheet

Posted by: jeff on 27 March 2020, 4:29 am EST

  • Posted 27 March 2020, 4:29 am EST

    Hello,

    I want to allow column and row resizing on a locked sheet. My intent is to prevent tables on the sheet from being edited.
  • Marked as Answer

    Replied 29 March 2020, 11:26 pm EST

    Hi Jeff,

    You may set allowResizeRows, allowResizeColumns protection option to true for making the rows and columns resizable in a locked sheet. Please refer to the following code snippet and the sample demonstrating the same:
    sheet.options.isProtected = true;
    sheet.options.protectionOptions.allowResizeRows=true;
    sheet.options.protectionOptions.allowResizeColumns=true;

    https://codesandbox.io/s/spread-js-starter-h0nsn

    Regards
    Sharad
  • Replied 30 March 2020, 9:57 am EST

    Thanks Sharad.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels