GetPreferredRowHeight(Int32,Boolean,Boolean) Method

Gets the height in pixels of the tallest cell (based on text content) in the specified row on this sheet.

Syntax

Visual Basic
C#

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

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

public float GetPreferredRowHeight( 
   int row,
   bool ignoreHeaders,
   bool ignoreSpans
)

Parameters

row: Row index
ignoreHeaders: Whether to ignore the row header cells
ignoreSpans: Whether to ignore spans

Return Value

Single-precision, floating-point number of pixels of the width of the cell with the tallest text in the column

Example

This example uses the GetPreferredRowHeight method.

float size;
size = fpSpread1.ActiveSheet.GetPreferredRowHeight(1, true, true);
listBox1.Items.Add(size.ToString());

Visual Basic

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

Reference

SheetView Class
SheetView Members
Overload List