Aspose.Cells.GridWeb.Examples.CSharp.Cells.AddFormulas.btnAddComplexFormula_Click C# (CSharp) Method

        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();
        }
    }