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

Free Support Forum - aspose.com

Excel iterative calculations

dear support,
does the Aspose.Cells library support Excel’s iterative setting ?
This setting is typically set when you specifically want to allow circular references.
kind regrads,
guido

@GuidoDeBouver,

Yes, it is supported. You may use WorkbookSettings.Iteration Boolean attribute to use iteration to resolve circular references. See the following sample code for your reference:
e.g
Sample code:

 var workbook = new Workbook("e:\\test2\\Book1.xlsx");
            workbook.Settings.Iteration = true;
            workbook.Settings.MaxIteration = 30;
            workbook.CalculateFormula();

Hope, this helps a bit.

Thank you.

thanks, will try and get back as needed