Spread Windows Forms 7.0 Product Documentation
GetPreferredWidth Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Column Class : GetPreferredWidth Method

Glossary Item Box

Gets the minimum width necessary to display all the text within the specified column.


Visual Basic (Declaration) 
Public Function GetPreferredWidth() As Single
Visual Basic (Usage)Copy Code
Dim instance As Column
Dim value As Single
value = instance.GetPreferredWidth()
public float GetPreferredWidth()

Return Value

Single-precision, floating-point number of pixels in the width


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.


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 BasicCopy 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


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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.