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.

import com.independentsoft.calc.CalcDiagnostic;
import com.independentsoft.calc.CalcDiagnosticKind;
import com.independentsoft.calc.CalcResult;
import com.independentsoft.calc.CalcSession;
import com.independentsoft.office.spreadsheet.Workbook;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Workbook book = new Workbook("c:\\test\\input.xlsx");

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

            System.out.println("Formula cells: " + result.getFormulaCellCount());
            System.out.println("Calculated: " + result.getCalculatedCellCount());
            System.out.println("Failed: " + result.getFailedCellCount());

            for (CalcDiagnostic diagnostic : result.getDiagnostics())
            {
                System.out.println(diagnostic.getKind() + " at " + diagnostic.getSheetName() + "!" + diagnostic.getCellReference());
                System.out.println("    formula: =" + diagnostic.getFormula());
                System.out.println("    detail: " + diagnostic.getDetail());

                if (diagnostic.getKind() == CalcDiagnosticKind.UnsupportedFunction)
                {
                    System.out.println("    this workbook uses a function the engine does not implement");
                }
            }
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

JCalc > Tutorial > Inspect the calculation result

Need help? Ask our developers: