We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Sheet/Workbook protection on server side?

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

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.