Forums Ultimate UI for WPF
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Tomas B
925
Protect the worksheet renaming
posted

Hi,

We have implementing usage of spreadsheet in application with read only mode. However we unable to find a way to protect the worksheet name as it is done in Excel.

I've check the documentation at Infragistics but did not found this option in description.

Is there way at the moment to protect the worksheet name from renaming?

  • 2680
    Verified Answer
    Offline posted
    Hello Tomas,
    In order to protect the worksheet from renaming, my suggestion is to use the the Workbook object’s Protect method to protect a workbook against structural changes like adding, renaming, reordering and deleting of worksheets. You could set its allowEditStructure parameter to false:
    workbook1.Protect(allowEditStructure: false);

    Аdditionally, I have attached a small sample that demonstrates this behavior below.
    You can find more information about disabling editing of a Worksheet here.
    If you require any further assistance on the matter, please let me know.
    Sincerely,
    Bozhidara Pachilova
    Associate Software Developer