Protect Sheet Cells while still Allowing Column Drag and Resize

Protect Sheet Cells while still Allowing Column Drag and Resize

Posted by: nathan.hanson on 28 September 2021, 3:43 pm EST

• 

  nathan.hanson

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 September 2021, 3:43 pm EST

  I’ve been using the WPF Spread control to display read-only output data from our software. I’m using the Protect property on the active sheet to make it so the user can’t edit the data in the cells. But my users need to be able to click and drag column headers to resize columns or reorder the columns and those seem to be blocked when Protected is true on the sheet. Is there another way to keep the cell data read only, while allowing resizing and reordering columns? Thanks!

• 

  nathan.hanson

  • Post Options:
  • Link
    Copy

  Posted 1 October 2021, 12:11 pm EST

  Bueller? Anyone have thoughts?

• 

  sonu.singh

  

  • Post Options:
  • Link
    Copy

  Posted 6 October 2021, 6:36 am EST

  Hi,
  
  Please check the below link for achieving you requirements.
  
  If this does not work then please share a small sample application with us. So that we can assist you accordingly.
  
  https://www.grapecity.com/spreadnet/docs/v14/online-wpf/tsresize.html
  
  https://www.grapecity.com/spreadnet/docs/v14/online-wpf/DragMoveF.html
  
  https://www.grapecity.com/spreadnet/docs/v14/online-wpf/ProjectLF.html

  Thanks!

• 

  nathan.hanson

  • Post Options:
  • Link
    Copy

  Posted 6 October 2021, 9:20 am EST

  Thank you for your response! Ultimately, to disable editing of cells while still allowing users to size and drag columns, my team handled the EditStarting event and immediately cancelled the operation. This prevents editing of cells while still allowing changes to heights, widths and column order. Posting to, hopefully, help others faced with this in the future.