Settings

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.

C#

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 8.2.0.3?

wb.Settings.CalcMode = CalcModeType.Automatic;


can this work in version 8.2.0.0?

Hi,

Thanks for using Aspose.Cells.

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

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

C#


Workbook wb = new Workbook();


wb.Settings.CalcMode = CalcModeType.Automatic;


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