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
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