Thanks for your posting and using Aspose.Cells.
Workbook.getSettings().setCalcMode() actually sets the calculation mode of MS-Excel for the given file. Please see the screenshot for your reference. It does not make Aspose.Cells to calculate the formulas automatically. In order to make Aspose.Cells calculate the formula, you need to use Workbook.calculateFormula() method.
You can also try Cell.calculate() method to calculate the formula of one cell only if you do not want to use Workbook.calculateFormula() method.
Hi guys. Do you have some method for recalc range?