Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Function GetPreferredWidth() As Single | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As Column Dim value As Single value = instance.GetPreferredWidth() | |
| C# | |
|---|---|
public float GetPreferredWidth() | |
Return Value
Single-precision, floating-point number of pixels in the widthRemarks
For text cells or header cells with text, be sure that you turn off word wrapping by setting the WordWrap property for that text cell or header cell to false.
Column widths can be based on the data in the cells using this method or SheetView.GetPreferredColumnWidth method. For more information, see Resizing the Row and Column to Fit the Data.
Example
This example determines the width of the column based on the text in the first cell.
| C# | Copy Code |
|---|---|
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; | |
| Visual Basic | Copy Code |
|---|---|
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 | |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
Reference
Column ClassColumn Members
GetPreferredColumnWidth Method