Autocalc not working

[erdnay]

My program creates a spreadsheet which has some calculations. It worked flawlessly on the development machine, but when tested on another computer, the formulas do not auto-calculate even though Options -> Formulas -> Workbook Calculation is set to Automatic. Pressing F9 does not calculate either. However click on the cell, click the formula bar, and click the little green check mark does make it calculate.

Any ideas?

Thanks

Alex

[Betsy.jiang]

Dear Alex,

Thanks for your inquiry.
There are two suggestions for you, please give it a try.
1. Upgrade to Spire.XLS Pack(Hotfix) Version:8.6.1 if you were using old version.
2. Add the code "workbook.CalculateAllValue();" before saving the file.

If you still has the issue, please provide us with following information for further investigation.
1. The input/output file and code you were using for showing the issue.
2. The OS and Region information of the computer which has the issue, e.g. Win7 64bit, China/Chinese.
3. The MS Excel Version you were using.

Sincerely,
Betsy
E-iceblue support team

[Betsy.jiang]

Dear Alex,

Greetings from E-iceblue.
How is your issue going now ? Could you please give us some feedback at your convenience ?

Sincerely,
Betsy
E-iceblue support team