Would it be possible to lock a cell but have the comments pop-up still editable?
Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
If you need to lock a cell but have the comments pop-up still editable, Please use Style.CellLocked property. Kindly consult the following code:
GridCell c = sheet.Cells["A1"];
Style s = c.GetStyle();
s.CellLocked = true;
You can also change the Style.CellLocked property from: right click to display context menu -> “Format Cells” window -> “Protection” Page ->”Locked” check box.
I've tried that and it seemed like when I set the CellLocked = true, the comment pop-up was also disabled.
I'll try it again.
My fault, I was setting the Protected property to true as well.