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,


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:
Sample code:

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

Hope, this helps a bit.

Thank you.

thanks, will try and get back as needed