Spread 8.0 Documentation
MaxTextRowHeight Property
Support Options
ActiveX Reference > ActiveX Properties > MaxTextRowHeight Property

Glossary Item Box

MaxTextRowHeight Property


See Also    DLL    Example

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

C++

double CSpreadSheet::GetMaxTextRowHeight(long lRow);

Visual Basic

[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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.