Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
240
Locking a worksheet column not working
posted

Hi,

I need to have an excel worksheet with one column editable (say first column) and rest read only. My code is as below:

_worksheet.Protected =

 

true;

_worksheet.Columns[0].CellFormat.Locked = ExcelDefaultableBoolean.False

However, it does not work. Instead if I add this piece of code, Infragistics removes the first column compeltely from my worksheet.

Could you please help.

Regards

Pallavi