Version 4.0.2.6
Intially shows as "#VALUE!". When I hit F2 and enter, it calucates the formula.
Workbook excelWorkbook0 = new Workbook();
Worksheet ws1 = excelWorkbook0.Worksheets[0];
ws1.Cells[0, 0].PutValue(1);
ws1.Cells[0, 2].Formula = "=A1";
ws1.Cells[0, 3].Formula = "=A1";
ws1.Cells[0, 4].Formula = "=A1";
ws1.Cells[0, 5].Formula = "=A1";
excelWorkbook0.CalculateFormula();
excelWorkbook0.Save(@"C:\Final.xls", FileFormatType.Default);