Currently, only Workbook/Worksheet could be protected. Would be nice to expose a way to protect cells for scenarios in which only particular cells should be locked for modifications.
Posted on:27 Apr 2016 12:46
This scenario can be implemented by setting IsLocked to all columns to false and set the same property to the cells you want to lock to true:
worksheet.Columns[0, SpreadsheetDefaultValues.ColumnCount - 1].SetIsLocked(false);