Aspose.Cells.GridWeb.Examples.CSharp.Cells.ProtectCells.chkSelectedCells_CheckedChanged C# (CSharp) Method

chkSelectedCells_CheckedChanged() protected method

protected chkSelectedCells_CheckedChanged ( object sender, EventArgs e ) : void
sender object
e EventArgs
return void
        protected void chkSelectedCells_CheckedChanged(object sender, EventArgs e)
        {
            chkAllCells.Checked = false;

            if (chkSelectedCells.Checked)
            {
                // ExStart:MakeSelectedCellsEditable
                // Accessing the reference of the worksheet that is currently active
                GridWorksheet sheet = GridWeb1.WorkSheets[GridWeb1.ActiveSheetIndex];

                // Setting all cells of the worksheet to Readonly first
                sheet.SetAllCellsReadonly();

                // Finally, Setting selected cells of the worksheet to Editable
                sheet.SetEditableRange(3, 2, 4, 1);
                // ExEnd:MakeSelectedCellsEditable

                Label1.Text = "4 rows and 1 column are editable starting from row 4 and column 3";
            }
            else
            {
                // ExStart:MakeSelectedCellsReadOnly
                // Accessing the reference of the worksheet that is currently active
                GridWorksheet sheet = GridWeb1.WorkSheets[GridWeb1.ActiveSheetIndex];

                // Setting all cells of the worksheet to Editable first
                sheet.SetAllCellsEditable();

                // Finally, Setting selected cells of the worksheet to Readonly
                sheet.SetReadonlyRange(3, 2, 4, 1);
                // ExEnd:MakeSelectedCellsReadOnly

                Label1.Text = "4 rows and 1 column are readonly starting from row 4 and column 3";
            }
        }
    }