Calculate an ODF spreadsheet

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

import com.independentsoft.calc.CalcResult;
import com.independentsoft.calc.CalcSession;
import com.independentsoft.office.odf.Cell;
import com.independentsoft.office.odf.Spreadsheet;
import com.independentsoft.office.odf.Table;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Spreadsheet document = new Spreadsheet();

            Table table = new Table("Sheet1");
            document.getTables().add(table);

            table.set("A1", new Cell(10.0));
            table.set("A2", new Cell(20.0));
            table.set("A3", new Cell(30.0));

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

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

            System.out.println(result);
            System.out.println("A4 = " + table.get("A4").getValue());

            document.save("c:\\test\\output.ods", true);
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

JCalc > Tutorial > Calculate an ODF spreadsheet

Need help? Ask our developers: