I'm using the eval software to determine if I can replace Excel Automation in an ASP app. At one point, I use the Excel application object's "Calculation" and "CalculateBeforeSave" methods to temporarily turn off Excel's calculation during subsequent operations. For example:
oWB_EUR.Application.Calculation = Excel.XlCalculation.xlCalculationManual;
oWB_EUR.Application.CalculateBeforeSave = true;
(oWB_EUR is an Excel workbook object).
Question: What does ASPOSE.Cells do about recalculation while I programmatically modify individual cells? Does it calculate at all? Are the Workbook.CalculateFormula methods in some way equivalent?