I was trying to lock a whole column at a time, but the style doesn't seem to be set when I use the following code:
//ws is the active worksheet
ws.Cells[Convert.ToByte(column)].Style.IsLocked = true;
When I check the worksheet afterwards, the columns are not locked at all. There are no other style manipulations on the cells/columns after this piece of code. Other style manipulations like
ws.Cells.Columns[Convert.ToByte(column)].Style.Custom = ApplicationSettings.AppDatePattern;
are performed on other columns and they do have affect.
Any help is welcome.