How can I help you?
How to overcome StackOverflow exception with IWorksheet’s Calculate()?
27 Mar 20261 minute to read
StackOverflow exception occurs when the number of IterationMaxCount, MaximumRecursiveCalls and MaxStackDepth exceeds in the CalcEngine. To avoid this StackOverflow exception while computing the formulas iteratively exceeding the maximum capacity, you need to set the values for these properties before calling the Calculate method of IWorksheet interface.
The following code snippet explains this.
worksheet.EnableSheetCalculations();
worksheet.CalcEngine.UseFormulaValues = true;
worksheet.CalcEngine.MaximumRecursiveCalls = 10000;
worksheet.CalcEngine.IterationMaxCount = 10000;
CalcEngine.MaxStackDepth = 10000;worksheet.EnableSheetCalculations();
worksheet.CalcEngine.UseFormulaValues = true;
worksheet.CalcEngine.MaximumRecursiveCalls = 10000;
worksheet.CalcEngine.IterationMaxCount = 10000;
CalcEngine.MaxStackDepth = 10000;worksheet.EnableSheetCalculations()
worksheet.CalcEngine.UseFormulaValues = True
worksheet.CalcEngine.MaximumRecursiveCalls = 10000
worksheet.CalcEngine.IterationMaxCount = 10000
CalcEngine.MaxStackDepth = 10000