Protect Sheet Cells while still Allowing Column Drag and Resize

Posted by: nathan.hanson on 28 September 2021, 6:43 am EST

    • Post Options:
    • Link

    Posted 28 September 2021, 6:43 am 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!

  • Posted 1 October 2021, 3:11 am EST

    Bueller? Anyone have thoughts? :grin:

  • Posted 5 October 2021, 9:36 pm EST


    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.


  • Posted 6 October 2021, 12: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.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels