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
WebWorksheet sheet = GridWeb1.WebWorksheets[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";
}
}
private void LoadGrid()
{
//Define maximum rows and columns
GridWeb1.MaxColumn = 3;
GridWeb1.MaxRow = 5;
//Create web worksheet object
WebWorksheet sheet = GridWeb1.WebWorksheets[0];
//Clear worksheet content
sheet.Cells.Clear();
//Adding a sample value and formatting to "B1" cell
sheet.Cells["B1"].PutValue("BMI Calculator");
sheet.Cells["B1"].GetStyle().BackColor = Color.Yellow;
sheet.Cells["B1"].GetStyle().ForeColor = Color.Green;
sheet.Cells["B1"].GetStyle().Font.Bold = true;
sheet.Cells["B1"].GetStyle().HorizontalAlign = HorizontalAlign.Center;
sheet.Cells["B1"].GetStyle().VerticalAlign = VerticalAlign.Middle;
//Merge B1 and B2 columns
sheet.Cells.Merge(0, 1, 1, 2);
//Set columns width
sheet.Cells.SetColumnWidth(1, new Unit("100pt"));
sheet.Cells.SetColumnWidth(2, new Unit("100pt"));
//Adding a sample value and formatting to "B3" cell
sheet.Cells["B3"].PutValue("Your Height(CM):");
sheet.Cells["B3"].GetStyle().BackColor = Color.Blue;
sheet.Cells["B3"].GetStyle().ForeColor = Color.Silver;
//Adding a sample value and formatting to "B4" cell
sheet.Cells["B4"].PutValue("Your Weight(KG):");
sheet.Cells["B4"].GetStyle().BackColor = Color.Blue;
sheet.Cells["B4"].GetStyle().ForeColor = Color.Silver;
//Adding a sample value and formatting to "B5" cell
sheet.Cells["B5"].PutValue("Your BMI is:");
sheet.Cells["B5"].GetStyle().BackColor = Color.Green;
sheet.Cells["B5"].GetStyle().ForeColor = Color.Silver;
//Adding a sample value and formatting to "B6" cell
sheet.Cells["B6"].PutValue("Evaluation:");
sheet.Cells["B6"].GetStyle().BackColor = Color.Green;
sheet.Cells["B6"].GetStyle().ForeColor = Color.Silver;
//Adding a formula value and formatting to "C5" cell
sheet.Cells["C5"].Formula = "=C4/(C3/100)^2";
sheet.Cells["C5"].GetStyle().BackColor = Color.LightGreen;
sheet.Cells["C5"].GetStyle().ForeColor = Color.Red;
sheet.Cells["C5"].GetStyle().HorizontalAlign = HorizontalAlign.Right;
Aspose.Cells.GridWeb.TableItemStyle style = new Aspose.Cells.GridWeb.TableItemStyle();
style.Custom = "0.00";
sheet.Cells["C5"].SetStyle(style);
//Adding a formula value and formatting to "C6" cell
sheet.Cells["C6"].Formula = "=IF(C5<18.5, \"Too Thin\", IF(C5<21, \"Good\", IF(C5<=23, \"Very Good\", IF(C5<=25, \"Good\", \"Too Fat\"))))";
sheet.Cells["C6"].GetStyle().BackColor = Color.LightGreen;
sheet.Cells["C6"].GetStyle().ForeColor = Color.Red;
sheet.Cells["C6"].GetStyle().HorizontalAlign = HorizontalAlign.Right;
//Adding validation and formatting to "C3" cell
sheet.Cells["C3"].CreateValidation(ValidationType.Number, true);
sheet.Cells["C3"].GetStyle().HorizontalAlign = HorizontalAlign.Right;
//Adding validation and formatting to "C4" cell
sheet.Cells["C4"].CreateValidation(ValidationType.Number, true);
sheet.Cells["C4"].GetStyle().HorizontalAlign = HorizontalAlign.Right;
//Adding formatting to "C3" and "C4" cells
sheet.SetAllCellsReadonly();
sheet.Cells["C3"].IsReadonly = false;
sheet.Cells["C4"].IsReadonly = false;
//Set GridWeb properties
GridWeb1.EnableAJAX = true;
GridWeb1.EnableClientColumnOperations = false;
GridWeb1.EnableClientFreeze = false;
GridWeb1.EnableClientMergeOperations = false;
GridWeb1.EnableClientRowOperations = false;
GridWeb1.EnableStyleDialogbox = false;
}
