Hello,
I defined a formula in a excel file. For example I set B3 to formula =SUM(B1:B2) in excel and save it as text2.xlsx. I set B1 and B2 in code as below:
var workbook = new Workbook();
workbook.LoadFromFile("test2.xlsx");
var sheet = workbook.Worksheets[0];
sheet.Range[1, 2].Value = "10";
sheet.Range[2, 2].Value = "10";
workbook.SaveToFile("ntest2.xlsx");
Console.ReadKey();
When I open ntest2.xlsx, I found the formual did not work. The B3 was 0.
Regards
Lei