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
I was not able to reproduce this issue. What version of the Excel library are you using? Also, in which file format are you saving your file?
I am using Infragisctics version 11.1.
I am trying to save the excel in 2007 format. I found that the same code works perfectly fine when I try to save the excel in Excel97To2003 format.
However, I need to save the file in 2007 format only. Is there any such limitation in 2007 format?
Thanks