Width Property (Column)

Visual Basic
C#

'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property Width As System.Double

'Usage
 
Dim instance As Column
Dim value As System.Double
 
instance.Width = value
 
value = instance.Width

[System.ComponentModel.DefaultValue()]
public System.double Width {get; set;}

Property Value

The width of cells in this column in pixels. The default value is 60 pixels.

Exception	Description
System.ArgumentOutOfRangeException	Specified width is out of range; must be between -1 and 9,999,999 pixels.

This example sets the Width property.

C#

GcSpreadSheet1.ActiveSheet.Columns[0].Width = 50;
GcSpreadSheet1.ActiveSheet.Columns[0].VerticalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellVerticalAlignment.Bottom;
GcSpreadSheet1.ActiveSheet.Columns[0].HorizontalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellHorizontalAlignment.Right;
GcSpreadSheet1.ActiveSheet.Rows[3].Height = 80;
GcSpreadSheet1.ActiveSheet.Rows[3].HorizontalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellHorizontalAlignment.Center;
GcSpreadSheet1.ActiveSheet.Rows[3].VerticalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellVerticalAlignment.Top;

private void button1_Click(object sender, RoutedEventArgs e)
{
        GcSpreadSheet1.ActiveSheet.Columns[0].ResetWidth();
        GcSpreadSheet1.ActiveSheet.Columns[0].ResetVerticalAlignment();
        GcSpreadSheet1.ActiveSheet.Columns[0].ResetHorizontalAlignment();
        GcSpreadSheet1.ActiveSheet.Rows[3].ResetHeight();
        GcSpreadSheet1.ActiveSheet.Rows[3].ResetHorizontalAlignment();
        GcSpreadSheet1.ActiveSheet.Rows[3].ResetVerticalAlignment();
}

VB.NET

GcSpreadSheet1.ActiveSheet.Columns(0).Width = 50
GcSpreadSheet1.ActiveSheet.Columns(0).VerticalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellVerticalAlignment.Bottom
GcSpreadSheet1.ActiveSheet.Columns(0).HorizontalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellHorizontalAlignment.Right
GcSpreadSheet1.ActiveSheet.Rows(3).Height = 80
GcSpreadSheet1.ActiveSheet.Rows(3).HorizontalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellHorizontalAlignment.Center
GcSpreadSheet1.ActiveSheet.Rows(3).VerticalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellVerticalAlignment.Top


Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
        GcSpreadSheet1.ActiveSheet.Columns(0).ResetWidth()
        GcSpreadSheet1.ActiveSheet.Columns(0).ResetVerticalAlignment()
        GcSpreadSheet1.ActiveSheet.Columns(0).ResetHorizontalAlignment()
        GcSpreadSheet1.ActiveSheet.Rows(3).ResetHeight()
        GcSpreadSheet1.ActiveSheet.Rows(3).ResetHorizontalAlignment()
        GcSpreadSheet1.ActiveSheet.Rows(3).ResetVerticalAlignment()
    End Sub

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

Column Class
Column Members