Calculate an ODF spreadsheet

The following example shows you how to calculate an OpenDocument spreadsheet (.ods). CalcSession takes an Independentsoft.Office.Odf.Spreadsheet directly and understands OpenFormula syntax, including the of: prefix and the [.A1] reference style.

C# example

using System;
using Independentsoft.Calc;
using Independentsoft.Office.Odf;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Spreadsheet document = new Spreadsheet();

            Table table = new Table("Sheet1");
            document.Tables.Add(table);

            table["A1"] = new Cell(10.0);
            table["A2"] = new Cell(20.0);
            table["A3"] = new Cell(30.0);

            Cell total = new Cell();
            total.Formula = "of:=SUM([.A1:.A3])";
            table["A4"] = total;

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

            Console.WriteLine(result);
            Console.WriteLine("A4 = " + table["A4"].Value);

            document.Save("c:\\test\\output.ods", true);
        }
    }
}

VB example

Imports System
Imports Independentsoft.Calc
Imports Independentsoft.Office.Odf

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

        Dim document As New Spreadsheet()

        Dim table As New Table("Sheet1")
        document.Tables.Add(table)

        table("A1") = New Cell(10.0)
        table("A2") = New Cell(20.0)
        table("A3") = New Cell(30.0)

        Dim total As New Cell()
        total.Formula = "of:=SUM([.A1:.A3])"
        table("A4") = total

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

        Console.WriteLine(result)
        Console.WriteLine("A4 = " & table("A4").Value)

        document.Save("c:\test\output.ods", True)

    End Sub
End Module

Calc .NET > Tutorial > Calculate an ODF spreadsheet

Need help? Ask our developers: