Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / Row Class / GetPreferredHeight Method

In This Topic
    GetPreferredHeight Method
    In This Topic
    Gets the minimum height necessary to display the text in all cells in this row.
    Public Function GetPreferredHeight() As Single
    Dim instance As Row
    Dim value As Single
    value = instance.GetPreferredHeight()
    public float GetPreferredHeight()

    Return Value

    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.

    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;
    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
    See Also