Free Support Forum - aspose.com

Simple Formula Problem

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

Please try this attached v4.0.2.7.

Thank you.

I still have another separate problem that I will post as another message.