Hi,
I need to lock the perticular column to protect making changes to column by users. That locked column should be read-only, it could not be editable and users can edit other columns.
The following code is not allowing me to lock the column.
Aspose.Cells.Style s = oWorksheet.Cells.Rows[1].Style;
s.IsLocked = true;
StyleFlag sf = new StyleFlag();
sf.Locked = true;
oWorksheet.Cells.Rows[1].ApplyStyle(s, sf);
The following statement is locking the columns properly, but making whole document as read-only.
oWorksheet.Protect(Aspose.Cells.ProtectionType.All);
Please suggest me how can i achieve this without locking whole worksheet?
Thanks,
Hi,
Please check the document for your reference:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/protecting-worksheets.html
Thank you.