GetPreferredHeight Method

Gets the minimum height necessary to display the text in all cells in this row.

Syntax

Visual Basic
C#

'Declaration
 
Public Function GetPreferredHeight() As Single

'Usage
 
Dim instance As Row
Dim value As Single
 
value = instance.GetPreferredHeight()

public float GetPreferredHeight()

Return Value

Single-precision, floating-point number of pixels in height

Remarks

Row heights can be based on the data in the cells using this method or SheetView.GetPreferredRowHeight method. For more information, see Resizing the Row and Column to Fit the Data.

Example

This example determines the height of the row based on the text in the first cell.

FarPoint.Win.Spread.Row row;
float size;
row = fpSpread1.ActiveSheet.Rows[0];
fpSpread1.ActiveSheet.Cells[0, 0].Text = "This text will be used to determine the height of the row.";
size = row.GetPreferredHeight();
row.Height = size;

Visual Basic

Dim row As FarPoint.Win.Spread.Row
Dim size As Single
row = FpSpread1.ActiveSheet.Rows(0)
FpSpread1.ActiveSheet.Cells(0, 0).Text = "This text will be used to determine the height of the row."
size = row.GetPreferredHeight()
row.Height = size

Requirements

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

Reference

Row Class
Row Members
GetPreferredRowHeight Method

User-Task Documentation

Resizing the Row or Column to Fit the Data