We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com


is there a slightly earlier version of aspose.dll that allows the use of this method? // Set Excel->Formula-> CalcMode to automatic so formulas are automatically calculated wb.Settings.CalcMode = CalcModeType.Automatic;

Hi Zen,

Thank you for contacting Aspose support.

You can find the WorkbookSettings.CalcMode property in recent releases as well. Please refer to the following code snippet.


var book = new Workbook();
book.Settings.CalcMode = CalcModeType.Automatic;

Please feel free to write back in case you need our further assistance.

does it exist in version 7.30 onwards but before

wb.Settings.CalcMode = CalcModeType.Automatic;

can this work in version


Thanks for using Aspose.Cells.

It also exists in older versions like so it must also exist in 7.3.0 which is newer than

I have tested it with the following code using the version I have attached the output Excel file generated by it for your reference.


Workbook wb = new Workbook();

wb.Settings.CalcMode = CalcModeType.Automatic;

wb.Save(“output-” + CellsHelper.GetVersion() + “.xlsx”);