Sheet/Workbook protection on server side?

Aspose.Cells Product Family
1

I notice that if I set either Worksheet or Workbook protection, for example:

_workbook.Worksheets["Sheet1"].Protection.AllowEditingContent = false;

I am still able to write values to the cells like this:

_workbook.Worksheets["Sheet1"].Cells[1, 1].Value = "This was added to a locked sheet!";

However, after I open the Excel file on the client system, the sheet behaves as expected, and the cells are locked.

  • Is this correct? Does the protection only take effect when the file is opened on the client?
  • Is there a way to honor the protection on the server?

Thanks,

Jeff

2

Hi,

Well, the worksheet protection settings are for MS Excel and will come to place when you open the file into MS Excel, so, it is not logically possible.

Thank you.