Not registered yet?
Register now! It is easy and done in 1 minute and gives you access to special discounts and much more!
I want to lock a cell that has a value calculated by a formula using EPSPlus.
So if a cell used in the formula is changed the cell value will change accordingly however the cell cannot be edited directly, is this possible?
just protect the worksheet and lock the required cell, this should not affect the formulas
worksheet.Protection.IsProtected = true;
worksheet.Cells["A1:B1"].Style.Locked = true;