Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Column Class / Width Property
Example


In This Topic
    Width Property (Column)
    In This Topic
    Gets or sets the width of this column.
    Syntax
    'Declaration
     
    Public Property Width As Integer
    'Usage
     
    Dim instance As Column
    Dim value As Integer
     
    instance.Width = value
     
    value = instance.Width
    public int Width {get; set;}

    Property Value

    Integer number of pixels in the width of this column
    Example
    This example creates a spreadsheet with 10 columns and 20 rows. A Column object is then created and assigned to the second column of the spreadsheet. The BackColor, ForeColor, Font and Width properties are set to various values and the text inserted into the column reflect the changes.
    FpSpread1.ActiveSheetView.ColumnCount=10;
    FpSpread1.ActiveSheetView.PageSize=20;
    FpSpread1.ActiveSheetView.RowCount=20;
    FarPoint.Web.Spread.Column mycol;
    mycol=FpSpread1.ActiveSheetView.Columns[1];
    mycol.BackColor=Color.Yellow;
    mycol.ForeColor=Color.Red;
    mycol.Font.Bold=true;
    mycol.Font.Name="ComicSansMS";
    mycol.Width=140;
    for(int i=0;i<FpSpread1.ActiveSheetView.RowCount;i++)
    {
    FpSpread1.ActiveSheetView.SetValue(i,1,"ColumnTest");
    }
    FpSpread1.ActiveSheetView.ColumnCount=10
    FpSpread1.ActiveSheetView.PageSize=20
    FpSpread1.ActiveSheetView.RowCount=20
    Dim mycol As FarPoint.Web.Spread.Column
    Dim col,i As Integer
    col=1
    mycol=FpSpread1.ActiveSheetView.Columns(col)
    mycol.BackColor=Color.Yellow
    mycol.ForeColor=Color.Red
    mycol.Font.Bold=True
    mycol.Font.Name="ComicSansMS"
    mycol.Width=140
    For i = 0 To FpSpread1.ActiveSheetView.RowCount-1
    FpSpread1.ActiveSheetView.SetValue(i,1,"ColumnTest")
    Next i
    See Also