using System;

using GemBox.Spreadsheet;

​

public class Program

{

    public static void Main()

    {

          // If using Professional version, put your serial key below.

        SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");

​

        var workbook = new ExcelFile();

        var worksheet = workbook.Worksheets.Add("Formula Calculation");

​

        // Some formatting.

        var row = worksheet.Rows[0];

        row.Style.Font.Weight = ExcelFont.BoldWeight;

​

        var column = worksheet.Columns[0];

        column.SetWidth(250, LengthUnit.Pixel);

        column.Style.HorizontalAlignment = HorizontalAlignmentStyle.Left;

        column = worksheet.Columns[1];

        column.SetWidth(250, LengthUnit.Pixel);

        column.Style.HorizontalAlignment = HorizontalAlignmentStyle.Right;

​

        // Use first row for column headers.

        worksheet.Cells["A1"].Value = "Formula";

        worksheet.Cells["B1"].Value = "Calculated value";

​

        // Enter some Excel formulas as text in first column.

        worksheet.Cells["A2"].Value = "1.50";

        worksheet.Cells["A3"].Value = "=A2*2";

        worksheet.Cells["A4"].Value = "2.30";

        worksheet.Cells["A5"].Value = "=A4*2";

        worksheet.Cells["A6"].Value = "1.30";

        worksheet.Cells["A7"].Value = "=A6*2";

        // Set text from first column as second row cell's formula.

        int rowIndex = 1;

        while (worksheet.Cells[rowIndex, 0].ValueType != CellValueType.Null)

            worksheet.Cells[rowIndex, 1].Formula = worksheet.Cells[rowIndex++, 0].StringValue;

​

        // GemBox.Spreadsheet supports single Excel cell calculation, ...

        worksheet.Cells["B2"].Calculate();

​

        // ... Excel worksheet calculation,

        worksheet.Calculate();

​

        // ... and whole Excel file calculation.

        worksheet.Parent.Calculate();

        decimal auxDecimal = 1.569m;

        Console.WriteLine(string.Format("{0:0.00}", auxDecimal));

        Console.WriteLine(worksheet.Cells["A2"].Name +":" + worksheet.Cells["A2"].Value + "\t" + worksheet.Cells["A3"].Value + "\t" + worksheet.Cells["B3"].Value );

        Console.WriteLine(worksheet.Cells["A4"].Name +":" + worksheet.Cells["A4"].Value + "\t" +worksheet.Cells["A5"].Value + "\t" + worksheet.Cells["B5"].Value );

        Console.WriteLine(worksheet.Cells["A6"].Name +":" + worksheet.Cells["A6"].Value + "\t" +worksheet.Cells["A7"].Value + "\t" + worksheet.Cells["B7"].Value );

​

        workbook.Save("Formula Calculation.xlsx");

    }

}