Hi Admin:

I want the value of some cells can be changed by user in the Aspose.Grid.Web and othders can't;At the same time,the width of column can be changed.

So, I do it as following step:

1.set some cells to lock and some cells to unlock.
2.load the Excel file in Aspose.Grid.Web.
3.set sheet.IsProtected = true;

result:  the value of some cells can be changed by user in the Aspose.Grid.Web and othders can't;But the width of column can't be changed.

if I set sheet.IsProtected = false;the width of column can be changed,but the value of all cells can be changed!

How can achieve my request,and which attribute has this feature;

Hi,

Well, when you protect a sheet, you cannot change the width or format columns / rows, this behavior is same as MS Excel.

I think you may try the following code for your task, you set all the cells read-only first then you may specify your editable range of cells, you may change the code accordingly:

WebWorksheets sheets = GridWeb1.WebWorksheets;

// Sets all cells readonly first.

// Starts from row 3, column 2, 11 rows 1 colum i.e., C4:C13.... total 10 cells.

WebCells cells = sheets[0].Cells;

Well, I see your way.

But in my system flow,I dont't know which cells need be edit by user in advance;

The user need to set  the formart of cells(e.g A1:Unlock;B1:Unlock;C1:Lock) in this Excel file before I load this file in my system by aspose.grid.web.

As your talk, If I want change the width of the clounm, I need set sheet.IsProtected = false;So,When I set sheet.IsProtected = false, How can I  know which cell's attribute is "Lock" or "Unlock"?

By the way, If I set the sheet.IsProtected = true, the user will can't change the value of cell when the cell is "Lock" in the Excel file.

pingmic:

As your talk, If I want change the width of the clounm, I need set sheet.IsProtected = false;So,When I set sheet.IsProtected = false, How can I  know which cell's attribute is "Lock" or "Unlock"?

Well, you may loop through all the cells and use WebCell.IsLocked property to check whether a cell is locked or not, see the following sample code:

WebWorksheet sheet = GridWeb1.WebWorksheets[0];

WebCells cells = sheet.Cells;

for (int i = 0; i <= cells.MaxRow; i++)

for (int j = 0; j <= cells.MaxColumn; j++)

WebCell cell = cells[i, j];

Response.Write("Cell:"+ cell.Name + ",Lock:" + cells[i,j].IsLocked.ToString() + "; ");

pingmic:

By the way, If I set the sheet.IsProtected = true, the user will can't change the value of cell when the cell is "Lock" in the Excel file.

Yes, that is true for MS Excel.

Thank you.