Allow column and row resizing on a protected sheet

Allow column and row resizing on a protected sheet

Posted by: jeff on 26 October 2019, 3:32 pm EST

• 

  jeff

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 26 October 2019, 3:32 pm EST

  How can I allow Column and Row resizing on a protected sheet. I want to protect the cell content not the formate.

• 

  jeff

  • Post Options:
  • Link
    Copy

  Posted 26 October 2019, 9:34 pm EST

  I found this post:
  
  https://www.grapecity.com/forums/spread-sheets/how-to-prevent-column-and-

  I simply want to make the rows and columns resizable. Can you provide a code sandbox please.
  
  codesandbox.io

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 28 October 2019, 8:40 am EST

  Hi Jeff,

  For enabling resizing on protected sheets, you could set the allowResizeRows and allowResizeColumns protection option to true. 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-2nobf

  Regards
  
  Sharad

• 

  jeff

  • Post Options:
  • Link
    Copy

  Posted 28 October 2019, 7:09 pm EST

  Thanks!