All cells are Locked by default. You must set Locked to False and then set Protected to True on the worksheet. Then you will be able to edit only the cells which are not locked. Also, if you know all cells in a row or column should be unlocked, you can set the Locked property on the cell format of the row or column. If this is not working correctly, it may be a bug and you can submit the issue to the support group: http://ko.infragistics.com/gethelp.
Thanks! I set the worksheet.locked = true as the first thing i do after creating it and it works fine.
Is there any way to put password protection on the worksheet? After creating the worksheet in code (and going to all the effort of locking cells etc) and saving it. All you need to do is open it in Excel and click "Unprotect worksheet" and all your hard work is lost. I can't seem to find a password property.