Predefined Formula not work

[zhenlei1970]

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

[rachel.lei]

Hello Lei,

Thanks for your inquiry.
Please add this line to recalculate the formula value. If there are any other questions, just feel free to let us know.

Code: Select all

            workbook.CalculateAllValue();
            //then save file...

Sincerely,
Rachel
E-iceblue support team

[zhenlei1970]

Thanks for your reply. It works now.

[rachel.lei]

Hello,

Glad to hear that!
Feel free to contact us if you need further assistance.
Have a nice day!

Sincerely,
Rachel
E-iceblue support team