Spread Windows Forms 9.0 Product Documentation
Width Property (Column)
Example 


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
System.ArgumentOutOfRangeException 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;
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

Column Class
Column Members

User-Task Documentation

Setting the Row Height or Column Width

 

 


Copyright © GrapeCity, inc. All rights reserved.