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

Glossary Item Box

RowHeight Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns the height of the specified row. This property is available at run time only.

Syntax

C++

double CSpreadSheet::GetRowHeight(long lRow);
void CSpreadSheet::SetRowHeight(long lRow, double value);

Visual Basic

[form.]fpSpread.RowHeight(lRow As Long)[ = value#]

Remarks

Specify the row for which you are setting the height using the lRow parameter. lRow values are zero-based. Use the following lRow values to designate the row height for the following parts of the control:

To set the row height for . . . Use lRow value . . .
Column headers 0
All rows –1
Row specified by the Row property –2

This setting is applied to the current sheet setting unless you first set the Sheet property to specify the sheet for which you are setting the property.

The units used for the RowHeight property are specified by the UnitType property. For example, if the UnitType property is set to 2 (Twips), specify the height in twips. If you return the height of a row and it is not in twips but you need it to be, use the RowHeightToTwips method to convert the value to twips.

Note: The value set or returned by the RowHeight property does not include the width of the adjacent grid line.

If you prefer, you can allow users to resize rows by setting the UserResize and UserResizeRow properties. If the user is allowed to resize rows, when the user resizes a row, the RowHeightChange event occurs.

Row heights can be based on the data in the cells or column using the MaxTextCellHeight and MaxTextRowHeight properties. For more information, see Resizing Columns and Rows to Fit Text and Resizing a Cell to Fit the Tallest Data.

Specify the width for columns using the ColWidth property.

Spread Designer

Choose the Sheet menu, then the Columns and Rows menu, select the Rows tab, and then type a number in the Row Height edit box in the Settings-Current Row group box in the Column and Row Settings dialog box.

Before setting the row height, select the row where you want to adjust the row height.

Data Type

Double

See Also

Resizing a Cell to Fit the Tallest Data
Resizing Columns and Rows to Fit Text
Setting the Height of Rows

ColWidth, MaxTextCellHeight, MaxTextRowHeight, Sheet, UnitType, UserResize, UserResizeRow properties

RowHeightChange event

RowHeightToTwips method

DLL Correspondence

SSGetRowHeight, SSSetRowHeight, SSGetRowHeightInPixels SSSetRowHeightInPixels functions

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