Worksheet Protection - Untick Select protected cells

[Adrian]

Dear Syncfusion,

I need to protect a worksheet using XlsIO but I am unable to find the right configuration on ExcelSheetProtection to untick this specific option on LibreOffice Calc

This is the current line of code that I am using:

sheet.Protect(passwd, ExcelSheetProtection.Objects Or ExcelSheetProtection.Scenarios Or ExcelSheetProtection.LockedCells Or ExcelSheetProtection.UnLockedCells)

Am I missing some of the ExcelSheetProtection enumeration?

Thank you

Adrian

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Adrian, 

Greetings form Syncfusion. 

We suggest you to try the below modified code snippet and let us know if the issue is resolved. 

Modified Code Snippet: 

sheet.Protect(passwd, ExcelSheetProtection.Objects And ExcelSheetProtection.Scenarios And Not ExcelSheetProtection.LockedCells And ExcelSheetProtection.UnLockedCells) 

If the issue still persists, kindly share the issue reproducing sample and confirm the Syncfusion XlsIO version you are using at your end, which will be helpful for us in investigating the query and provide prompt solution at the earliest. 

Regards, 

Keerthi. 

[Adrian]

Hi Keerthi,

this allows me to untick both of the options, I just need to prevent selection on protected cells, not on unprotected ones too.

This is the desired configuration:

But with your help I managed to find the solution

sht.Protect(passwd, ExcelSheetProtection.Objects And ExcelSheetProtection.Scenarios And Not ExcelSheetProtection.LockedCells Or ExcelSheetProtection.UnLockedCells)

Thank you

Best regards
Adrian

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Adrian, 

We are glad that the provided suggestion helped you. Kindly let us know if you need any further assistance. 

Regards, 

Keerthi.