Free Support Forum - aspose.com

How protecte a cell?

Aspose.Cells Product Family
#1

hi :

In Aspose.cells ,I can protect sheet ,But I want to protecte a cell ,eg: excel.WorkSheet[0].cells[1,1] ---protect ? Please tell me what can i do ?

Thanks

Jackmeng

#2

It's not an easy job as you wish. Do you know how to do it in MS Excel?

You can try:

for(int i = 0; i < 255; i ++)

excel.Worksheets[0].ColumnsIdea [I].Style.IsLocked = false;

excel.Worksheets[0].Cells[1,1].Style.IsLocked = true;

excel.Worksheets[0].Protect(ProtectionType.All);

#3

Sorry this method

for(int i = 0; i < 255; i ++)

excel.Worksheets[0].ColumnsIdea <img src=" src="/Community/emoticons/emotion-55.gif">.Style.IsLocked = false;

excel.Worksheets[0].Cells[1,1].Style.IsLocked = true;

excel.Worksheets[0].Protect(ProtectionType.All);

Is not right !

Help?

#4

Please check this attached sample code.

#5

Thank you very much!