Protected sheet not resizable

Protected sheet not resizable

Posted by: ellie.oosterhof on 23 August 2024, 11:06 am EST

• 

  ellie.oosterhof

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 23 August 2024, 11:06 am EST

  Hello
  
  We have a sheet where we want to lock certain cells, so I have to set the sheet to protected.
  
  However, on that moment it is not possible to resize the columns.
  
  Is there a way to achieve that the user still can resize the columns? Setting a default size of the max width is no option as some columns can contain a long text.

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 26 August 2024, 10:45 pm EST

  Hi Ellie,

  We are currently discussing this issue with our developers. [Internal Tracking ID: SPNET-41476]

  We will update you on this as soon as we hear back from them.

  Thanks & regards,
  
  Aastha

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 29 August 2024, 2:42 am EST

  Hi Ellie,

  You can protect the FpSpread’s SheetView using the following line of code:

  fpSpread1.AsWorkbook().ActiveSheet.Protect(WorksheetLocks.Default & ~(WorksheetLocks.FormatColumns | WorksheetLocks.FormatRows));

  This code allows you to resize rows and columns even for the protected sheet. Refer ProtectSheetDemo.zip

  Thanks & Regards,
  
  Aastha

• 

  ellie.oosterhof

  • Post Options:
  • Link
    Copy

  Posted 6 September 2024, 9:03 am EST - Updated 6 September 2024, 9:04 am EST

  sorry did not look well, edited post

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 9 September 2024, 8:11 am EST

  Hi Ellie,

  >sorry did not look well, edited post

  Could you please clarify the above comment that you have given? Is the issue resolved on your end or you need some help?

  Kind Regards,
  
  Aastha

• 

  ellie.oosterhof

  • Post Options:
  • Link
    Copy

  Posted 9 September 2024, 8:14 am EST

  yes the issue is solved. I had added a comment but did not look well, i could not remove the comment anymore so I changed it

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 10 September 2024, 7:44 am EST

  Hi Ellie,

  We are glad to hear that the issue is resolved on your end.

  Thanks for your confirmation.

  Kind Regards,
  
  Aastha