does the Aspose.Cells library support Excel’s iterative setting ?
This setting is typically set when you specifically want to allow circular references.
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:
var workbook = new Workbook("e:\\test2\\Book1.xlsx"); workbook.Settings.Iteration = true; workbook.Settings.MaxIteration = 30; workbook.CalculateFormula();
Hope, this helps a bit.
thanks, will try and get back as needed