Content validation

The following example shows how to add content validation rules to cells in an ODS spreadsheet.

import com.independentsoft.office.odf.Cell;
import com.independentsoft.office.odf.ContentValidation;
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("Validation");

            ContentValidation validation = new ContentValidation();
            validation.setName("val1");
            validation.setCondition("cell-content-is-between(1, 100)");
            validation.setAllowEmptyCell(true);
            doc.getContentValidations().add(validation);

            Cell a1 = new Cell(50.0);
            a1.setContentValidation("val1");
            table.set("A1", a1);

            Cell a2 = new Cell(75.0);
            a2.setContentValidation("val1");
            table.set("A2", a2);

            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 > Content validation

Need help? Ask our developers: