Cell spanning

The following example shows how to merge cells across columns and rows 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 = "Spanning";

            Cell mergedHeader = new Cell("Merged Header");
            mergedHeader.SpannedColumnsCount = 3;
            table1["A1"] = mergedHeader;
            table1["B1"] = new CoveredCell();
            table1["C1"] = new CoveredCell();

            Cell tallCell = new Cell("Tall Cell");
            tallCell.SpannedRowsCount = 2;
            table1["A2"] = tallCell;
            table1["A3"] = new CoveredCell();
            table1["B2"] = new Cell("Row 1, Col 2");
            table1["B3"] = new Cell("Row 2, Col 2");

            Spreadsheet spreadsheet = new Spreadsheet();
            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 = "Spanning"

        Dim mergedHeader As New Cell("Merged Header")
        mergedHeader.SpannedColumnsCount = 3
        table1("A1") = mergedHeader
        table1("B1") = New CoveredCell
        table1("C1") = New CoveredCell

        Dim tallCell As New Cell("Tall Cell")
        tallCell.SpannedRowsCount = 2
        table1("A2") = tallCell
        table1("A3") = New CoveredCell
        table1("B2") = New Cell("Row 1, Col 2")
        table1("B3") = New Cell("Row 2, Col 2")

        Dim spreadsheet As New Spreadsheet
        spreadsheet.Tables.Add(table1)

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

IndependentsoftProfessional software libraries for developers

ODF .NET > Tutorial > Cell spanning

Need help? Ask our developers: