Spreadsheet formulas

The following example shows how to add formulas to cells in an ODS spreadsheet.

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 doc = new Spreadsheet();
            Table table = new Table();
            table.setName("Formulas");

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

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

            Cell b1 = new Cell(20.0);
            b1.setFormula("of:=[.A1]*2");
            table.set("B1", b1);

            Cell b2 = new Cell(20.0);
            b2.setFormula("of:=AVERAGE([.A1:.A3])");
            table.set("B2", b2);

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

IndependentsoftProfessional software libraries for developers

JODF > Tutorial > Spreadsheet formulas

Need help? Ask our developers: