Allow setColumnResizable and setrowResizable on Locked Sheet

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

    • Post Options:
    • Link

    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.

  • Posted 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

  • Posted 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