Set column width

The following example shows you how to set column width. See screenshot.

C# example

using System;
using Independentsoft.Odf;
using Independentsoft.Odf.Styles;

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

            ColumnStyle columnStyle1 = new ColumnStyle("CO1");
            columnStyle1.Width = new Size(3, Unit.Inch);

            spreadsheet.AutomaticStyles.Styles.Add(columnStyle1);

            Column column1 = new Column();
            column1.Style = "CO1";

            Table sheet1 = new Table();
            sheet1.Columns.Add(column1);

            spreadsheet.Tables.Add(sheet1);

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

VB example

Imports System
Imports Independentsoft.Odf
Imports Independentsoft.Odf.Styles

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

        Dim spreadsheet As New Spreadsheet()

        Dim columnStyle1 As New ColumnStyle("CO1")
        columnStyle1.Width = New Size(3, Unit.Inch)

        spreadsheet.AutomaticStyles.Styles.Add(columnStyle1)

        Dim column1 As New Column()
        column1.Style = "CO1"

        Dim sheet1 As New Table()
        sheet1.Columns.Add(column1)

        spreadsheet.Tables.Add(sheet1)

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

    End Sub
End Module