CellLocked Property - Comments

Aspose.Cells Product Family
1

Would it be possible to lock a cell but have the comments pop-up still editable?

2

Hi,

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;

c.SetStyle(s);

You can also change the Style.CellLocked property from: right click to display context menu → “Format Cells” window → “Protection” Page ->”Locked” check box.

Thank you.

3

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.

4

My fault, I was setting the Protected property to true as well.