Hi Winson,
Thank you for using Syncfusion products.
There are two possibilities in a excel file for the reported manual calculation.
1. The "Calculation Option" in Formulas menu might be set to "Manual" instead of "Automatic"
This can be rectified in XlsIO with the following code snippet.
workbook.CalculationOptions.CalculationMode = ExcelCalculationMode.Automatic;
2. The generated excel file might be opened under protected mode. But, enabling the protection will perform calculation.
Kindly check the above points and get back to us with your sample by creating an incident from
Direct Trac if the problem still exists.
Please let us know if you need any clarification.
Thanks,
Johnson