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.
Forums Home / Spread / SpreadJS
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.
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.