Free Support Forum -

Simple Formula Problem


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.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.