Free Support Forum - aspose.com

Calculation options default to "Automatic" in excel templates

Hi,
We are currently using aspose cells for .net (ver 4.7.1.0).

We have a routine where we open excel template files, work with them and save the output files based on the input file excel type(2003-xlt or 2007-xltx).
When the template file is an excel 2003 one (test.xlt), and the formula Calculation option (Tools->Options->Calculation) is set to manual the resulting xls file maintains the manual calculation option but when the template file is an excel 2007 one(test.xltx), the ouput xlsx file defaults back to the automatic calculation option even though it was set to manual.

Could you look into this and let us know how to achieve the same result in the 2007 flavor too.

thanks,
Jaideep.

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Please try the attached latest version of Aspose.Cells. I checked your issue with the attached latest version and it works fine. If you still face any problem, please share your template file here and we will check it soon.

Thank You & Best Regards,