GetPreferredColumnWidth(Int32,Boolean,Boolean) Method

Gets the width of the widest cell (based on text content) in the specified column on this sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function GetPreferredColumnWidth( _
   ByVal column As Integer, _
   ByVal ignoreHeaders As Boolean, _
   ByVal ignoreSpans As Boolean _
) As Single

'Usage
 
Dim instance As SheetView
Dim column As Integer
Dim ignoreHeaders As Boolean
Dim ignoreSpans As Boolean
Dim value As Single
 
value = instance.GetPreferredColumnWidth(column, ignoreHeaders, ignoreSpans)

public float GetPreferredColumnWidth( 
   int column,
   bool ignoreHeaders,
   bool ignoreSpans
)

Parameters

column: Column index
ignoreHeaders: Whether to ignore column header cells
ignoreSpans: Whether to ignore spans

Return Value

Single-precision, floating-point number of pixels of the width of the cell with the widest text in the row

Example

This example uses the GetPreferredColumnWidth method.

float size;
size = fpSpread1.ActiveSheet.GetPreferredColumnWidth(0, true, true);
listBox1.Items.Add(size.ToString());

Visual Basic

Dim Size As Integer
Size = fpSpread1.ActiveSheet.GetPreferredColumnWidth(0, True, True)
ListBox1.Items.Add(Size.ToString())

Reference

SheetView Class
SheetView Members
Overload List