Allow setColumnResizable and setrowResizable on Locked Sheet

Allow setColumnResizable and setrowResizable on Locked Sheet

Posted by: jeff on 27 March 2020, 1:29 pm EST

• 

  jeff

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 27 March 2020, 1:29 pm 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.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 30 March 2020, 8:26 am 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

• 

  jeff

  • Post Options:
  • Link
    Copy

  Posted 30 March 2020, 6:57 pm EST

  Thanks Sharad.