Making spreadsheet,column/rows as ready only

[Manikandan]

Hi,
I'm using owc11 for my c# application.
I'm creating a excel spread sheet with data's programmatically.
I have written codes for double click event handler.
if the data in cell is in edit mode means, double click event handler
won't work.
I tried the properties like locked,editmode, protection , all gives
error in compilation itself.
I would like to make whole sheet as readonly, or each columns/rows to
read only.
Is there any method/property available to make columns/rows as
readonly in spreadsheet?

Thanks,
Mani

 

[Vapordan]

Yes, you can lock at various levels to include cells, ranges, sheets,
workbook etc. Each object has a lock property which is a recommendation to
the spreadsheet that protection must be used. To actually lock the object,
you must set the protection object to true.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99