Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / Column Class / Width Property
Example


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

    Property Value

    Value of the width in pixels
    Exceptions
    ExceptionDescription
    Specified width is out of range; must be between -1 and 9,999,999 pixels
    Remarks

    This is equivalent to the SheetView.SetColumnWidth method. For more information on setting the size of the column, refer to Setting the Row Height or Column Width.

    Column widths can be based on the data in the cells using the GetPreferredWidth method or SheetView.GetPreferredColumnWidth method. For more information, see Resizing the Row and Column to Fit the Data.

    You can allow users to resize columns by setting the Resizable property. If the user is allowed to resize columns, when the user resizes a column, the FpSpread.ColumnWidthChanged and SheetView.ColumnChanged events occur.

    Example
    This example determines the width of the column based on the text in the first cell.
    Dim col As FarPoint.Win.Spread.Column
    Dim size As Single
    col = fpSpread1.ActiveSheet.Columns(0)
    fpSpread1.ActiveSheet.Cells(0, 0).Text = "This text will be used to determine the width of the column"
    size = col.GetPreferredWidth()
    col.Width = size
    FarPoint.Win.Spread.Column col;
    float size;
    col = fpSpread1.ActiveSheet.Columns[0];
    fpSpread1.ActiveSheet.Cells[0, 0].Text = "This text will be used to determine the width of the column";
    size = col.GetPreferredWidth();
    col.Width = size;
    See Also