We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Multiple Cell Select

Is there any way to turn off multi-cell select on the GridWeb control?


I’ve attached a screen capture to further clarify.

Thanks.

Hi,


I think you may try to make your desired cells read-only and editable accordingly, see the demo:
http://www.aspose.com/demos/.net-components/aspose.cells/csharp/grid/common/data-validation.

Also, you may try to protect a worksheet and then specify which cells you want should be editable, all other cells would be locked, see the sample code:
e.g
WebWorksheets sheets = GridWeb1.WebWorksheets;
WebWorksheet sheet = sheets[0];

//Since all the cell are locked by default same as MS Excel.
//Set A1 cell and B1 not locked.
sheet.Cells[0, 0].IsLocked = false;
//Set A2 Cell not locked
sheet.Cells[1, 0].IsLocked = false;
//Protect the sheet.
sheet.IsProtected = true;


Thank you.