MaxTextRowHeight Property
Applies To
fpSpread control
Description
Returns the height of the tallest text string in the specified row. This property is available at run time only.
Syntax
double CSpreadSheet::GetMaxTextRowHeight(long lRow);
[form.]fpSpread.MaxTextRowHeight(lRow As Long)
Remarks
This setting is returned for the current sheet setting unless you first set the Sheet property to specify the sheet for which you are returning the property. Specify the row using the lRow parameter.
You can set the RowHeight property equal to the value returned from this property to size the row to display all the text in the specified row.
For edit and static text cells, the value returned varies depending on the setting of the TypeEditMultiLine property (for edit cells) or the TypeTextWordWrap property (for static text cells), as listed in the following table.
| TypeEditMultiLine or TypeTextWordWrap property setting | Value returned |
|---|---|
| True | The minimum row height necessary to display all the text in the row given the current column width and font size |
| False | The minimum row height necessary to display one line of text given the current font size |
You can base the row height on the text in a cell instead of the specified row by using the MaxTextCellHeight property.
You can perform similar calculations for the column width using the MaxTextCellWidth and MaxTextColWidth properties.
Data Type
Double
See Also
Resizing a Cell to Fit the Tallest Data
Resizing Columns and Rows to Fit Text
MaxTextCellHeight, MaxTextCellWidth, MaxTextColWidth, RowHeight, TypeEditMultiLine, TypeTextWordWrap properties
DLL Correspondence
SSGetMaxTextRowHeight function