protected void btnAddComplexFormula_Click(object sender, EventArgs e)
{
// Clear GridWeb
GridWeb1.WorkSheets.Clear();
// Add worksheets
GridWorksheet sheet1 = GridWeb1.WorkSheets.Add("Sheet1");
GridWorksheet sheet2 = GridWeb1.WorkSheets.Add("Sheet2");
// Putting some values to cells
sheet1.Cells["A1"].PutValue(10);
sheet1.Cells["A2"].PutValue(20);
sheet1.Cells["A3"].PutValue(30);
sheet1.Cells["A4"].PutValue(40);
sheet1.Cells["A5"].PutValue(50);
sheet1.Cells["B1"].PutValue(1);
sheet1.Cells["B2"].PutValue(2);
sheet1.Cells["B3"].PutValue(3);
sheet1.Cells["B4"].PutValue(4);
sheet1.Cells["B5"].PutValue(5);
sheet2.Cells["A1"].PutValue("Value for reference : ");
sheet2.Cells["B1"].PutValue(100);
sheet1.Cells["A6"].PutValue("Result");
// ExStart:AddComplexFormulas
// Adding a bit complex formula to "A1" cell
sheet1.Cells["B6"].Formula = "=(SUM(A1:A5)/AVERAGE(B1:B5))-Sheet2!B1";
// ExEnd:AddComplexFormulas
// Calculating all formulas added in worksheets
GridWeb1.WorkSheets.CalculateFormula();
}
}