Locking Cells not working

[surfdmountain]

I'm trying to lock specific cells from editing (not the entire sheet).

sheet.Range["A1"].Style.Locked = true;
sheet.Protect("123", SheetProtectionType.All);

the above doesn't work, it locks the entire sheet out and no cell can be edited. When the protection is removed, all cells are editable.
I also tried:

sheet.Protect("123", SheetProtectionType.LockedCells);

Still doesn't work.
I'm just trying to set a column (or cell) to read-only.

[surfdmountain]

I figured this out. Now I can define which cells are read only.
By default, all my cells were locked. You must explicitly define cells as unlocked.

sheet.Range["A1"].Style.Locked = false;

Then use this:

sheet.Protect("123", SheetProtectionType.UnLockedCells);

Setting the sheet protection type to Unlocked Cells will ALLOW unlocked cells to be edited.

Using sheet.Protect("123", SheetProtectionType.All); will make all the cells editable, locked or not.

[Annika.Zhou]

Hello,

Glad to hear that the solution has been found by yourself.
If you encounter other issues related to our products in the future, please feel free to contact us. Wish you all the best!

Sincerely,
Annika
E-iceblue support team