Define name

The following example shows you how to define range name.

C# example

using System;
using Independentsoft.Office.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\\output.ods", true);
        }
    }
}

VB example

Imports System
Imports Independentsoft.Office.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\output.ods", True)

    End Sub
End Module

Independentsoft - any library, any programming language

ODF .NET > Tutorial > Define name

Need help? Ask our developers: