Last Updated: 27 Apr 2016 12:46 by ADMIN
Created on: 13 Jan 2016 13:03
Category: Spreadsheet
Type: Feature Request
Implement cell protection
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.
(Total attached files size should be smaller than 20mb. Allowed extensions: .zip, .rar, .jpg, .png, .gif)
1 comment
Nikolay Demirev
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);
worksheet.Cells[0, 0].SetIsLocked(true);