Define name

The following example shows you how to define range name. See screenshot.

C# example

using System;
using Independentsoft.Odf;

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

            Table sheet1 = new Table("Sheet1");
            spreadsheet.Tables.Add(sheet1);

            NamedRange range1 = new NamedRange("MyRange");
            range1.CellRangeAddress = "$Sheet1.$A$1:.$C$1";
            range1.BaseCellAddress = "$Sheet1.$C$1";

            spreadsheet.NamedElements.Add(range1);

            spreadsheet.Save("c:\\test.ods");
        }
    }
}

VB example

Imports System
Imports Independentsoft.Odf

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

        Dim spreadsheet As New Spreadsheet()

        Dim sheet1 As New Table("Sheet1")
        spreadsheet.Tables.Add(sheet1)

        Dim range1 As New NamedRange("MyRange")
        range1.CellRangeAddress = "$Sheet1.$A$1:.$C$1"
        range1.BaseCellAddress = "$Sheet1.$C$1"

        spreadsheet.NamedElements.Add(range1)

        spreadsheet.Save("c:\test.ods")

    End Sub
End Module