Inspect the calculation result

The following example shows you how to inspect the CalcResult returned by CalcSession. Every cell that could not be fully calculated produces a CalcDiagnostic that names the sheet, the cell, the reason and the formula. Such a cell keeps its original cached value, so nothing is lost.

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\\input.xlsx");

            CalcSession session = new CalcSession();
            CalcResult result = session.Calculate(book);

            Console.WriteLine("Formula cells: " + result.FormulaCellCount);
            Console.WriteLine("Calculated: " + result.CalculatedCellCount);
            Console.WriteLine("Failed: " + result.FailedCellCount);

            foreach (CalcDiagnostic diagnostic in result.Diagnostics)
            {
                Console.WriteLine(diagnostic.Kind + " at " + diagnostic.SheetName + "!" + diagnostic.CellReference);
                Console.WriteLine("    formula: =" + diagnostic.Formula);
                Console.WriteLine("    detail: " + diagnostic.Detail);

                if (diagnostic.Kind == CalcDiagnosticKind.UnsupportedFunction)
                {
                    Console.WriteLine("    this workbook uses a function the engine does not implement");
                }
            }
        }
    }
}

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\input.xlsx")

        Dim session As New CalcSession()
        Dim result As CalcResult = session.Calculate(book)

        Console.WriteLine("Formula cells: " & result.FormulaCellCount)
        Console.WriteLine("Calculated: " & result.CalculatedCellCount)
        Console.WriteLine("Failed: " & result.FailedCellCount)

        For Each diagnostic As CalcDiagnostic In result.Diagnostics
            Console.WriteLine(diagnostic.Kind.ToString() & " at " & diagnostic.SheetName & "!" & diagnostic.CellReference)
            Console.WriteLine("    formula: =" & diagnostic.Formula)
            Console.WriteLine("    detail: " & diagnostic.Detail)

            If diagnostic.Kind = CalcDiagnosticKind.UnsupportedFunction Then
                Console.WriteLine("    this workbook uses a function the engine does not implement")
            End If
        Next

    End Sub
End Module

Calc .NET > Tutorial > Inspect the calculation result

Need help? Ask our developers: