Content validation

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

C# example

using System;
using Independentsoft.Office.Odf;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Table table1 = new Table();
            table1.Name = "Validation";

            ContentValidation validation = new ContentValidation();
            validation.Name = "val1";
            validation.Condition = "of:cell-content-is-between(1;10)";
            validation.AllowEmptyCell = true;

            Spreadsheet spreadsheet = new Spreadsheet();
            spreadsheet.ContentValidations.Add(validation);

            Cell cell1 = new Cell(5.0);
            cell1.ContentValidation = "val1";
            table1["A1"] = cell1;

            Cell cell2 = new Cell(7.0);
            cell2.ContentValidation = "val1";
            table1["A2"] = cell2;

            spreadsheet.Tables.Add(table1);
            spreadsheet.Save("c:\\test\\output.ods", true);
        }
    }
}

VB example

Imports System
Imports Independentsoft.Office.Odf

Module Module1
    Sub Main(ByVal args() As String)
        Dim table1 As New Table
        table1.Name = "Validation"

        Dim validation As New ContentValidation
        validation.Name = "val1"
        validation.Condition = "of:cell-content-is-in-list(""A"";""B"";""C"")"
        validation.AllowEmptyCell = True

        Dim spreadsheet As New Spreadsheet
        spreadsheet.ContentValidations.Add(validation)

        Dim cell1 As New Cell("A")
        cell1.ContentValidation = "val1"
        table1("A1") = cell1

        Dim cell2 As New Cell("B")
        cell2.ContentValidation = "val1"
        table1("A2") = cell2

        spreadsheet.Tables.Add(table1)
        spreadsheet.Save("c:\test\output.ods", True)
    End Sub
End Module

IndependentsoftProfessional software libraries for developers

ODF .NET > Tutorial > Content validation

Need help? Ask our developers: