SSpread.RowHeight Property
Set the row height.
This property is an Index Property. Specify the following values for the index.
| Index | Description |
|---|---|
| 0 | Column header |
| -1 | All rows |
| -2 | Row specified by Row property |
| Other | Row number |
The initial value is 15.
The width of the column is set with the ColWidth property.
To allow the user to change the row height, set the UserResize and UserResizeRow properties. The RowHeightChange event is raised when the user changes the row height.
You can use the MaxTextCellheight and MaxTextRowheight properties to get the required height based on the data set in the cell.
Example of usage
RowHeight(-1) = 20;
RowHeight(2) = 40;
Row = 3;
RowHeight(-2) = 60;
print(RowHeight(1), RowHeight(2), RowHeight(3), "\n");
Related Items
MaxTextCellheight, MaxTextRowheight, ColWidth, UserResize, UserResizeRow property
RowHeightChange event