Gets the width of the widest cell (based on text content) in the specified column on this sheet.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overloads Function GetPreferredColumnWidth( _
ByVal column As Integer, _
ByVal As Boolean _
) As Single |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim column As Integer
Dim ignoreHeaders As Boolean
Dim value As Single
value = instance.GetPreferredColumnWidth(column, ignoreHeaders) |
Parameters
- column
- Column index
- ignoreHeaders
- Whether to ignore column header cells
Return Value
Single-precision, floating-point number of pixels of the width of the cell with the widest text in the row
Remarks
Example
| C# | Copy Code |
|---|
float size;
size = fpSpread1.ActiveSheet.GetPreferredColumnWidth(0, true);
listBox1.Items.Add(size.ToString())
|
| Visual Basic | Copy Code |
|---|
Dim f As Integer
i = FpSpread1.ActiveSheet.GetPreferredColumnWidth(0, True)
ListBox1.Items.Add(i.ToString())
|
Requirements
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
