Limit the evaluation steps

The following example shows you how to bound the work a single calculation may do. CalcOptions.MaxEvaluationSteps is a safety guard against pathological dependency chains in untrusted workbooks. When the limit is reached the run stops and the affected cells are reported as EvaluationAborted diagnostics.

C# example

using System;
using Independentsoft.Calc;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook book = new Workbook("c:\\test\\untrusted.xlsx");

            CalcSession session = new CalcSession();
            session.Options.MaxEvaluationSteps = 1000000;

            CalcResult result = session.Calculate(book);

            foreach (CalcDiagnostic diagnostic in result.Diagnostics)
            {
                if (diagnostic.Kind == CalcDiagnosticKind.EvaluationAborted)
                {
                    Console.WriteLine("Aborted at " + diagnostic.SheetName + "!" + diagnostic.CellReference);
                }
            }
        }
    }
}

VB example

Imports System
Imports Independentsoft.Calc
Imports Independentsoft.Office.Spreadsheet

Module Module1
    Sub Main(ByVal args As String())

        Dim book As New Workbook("c:\test\untrusted.xlsx")

        Dim session As New CalcSession()
        session.Options.MaxEvaluationSteps = 1000000

        Dim result As CalcResult = session.Calculate(book)

        For Each diagnostic As CalcDiagnostic In result.Diagnostics
            If diagnostic.Kind = CalcDiagnosticKind.EvaluationAborted Then
                Console.WriteLine("Aborted at " & diagnostic.SheetName & "!" & diagnostic.CellReference)
            End If
        Next

    End Sub
End Module

Calc .NET > Tutorial > Limit the evaluation steps

Need help? Ask our developers: