SSGetMaxRows, SSSetMaxRows Functions
Applies To
fpSpread DLL control
Description
Set or return the maximum number of usable rows in the sheet.
Syntax
SS_COORD SSGetMaxRows(HWND hWnd);
void SSSetMaxRows(HWND hWnd, SS_COORD MaxRows);
SS_COORD TSpread::GetMaxRows( );
void TSpread::SetMaxRows(SS_COORD MaxRows);
Parameters
The SSGetMaxRows function has the following parameter:
| Parameter | Description |
| hWnd | Window handle of the fpSpread control |
The SSSetMaxRows function has the following parameters:
| Parameter | Description |
|---|---|
| hWnd | Window handle of the fpSpread control |
| MaxRows | Number of rows allowed in sheet |
Remarks
This function is applied to the current sheet setting unless you first call the SSSetSheet function to specify the sheet for which you are calling this function.
The maximum value can be any value from zero through two billion. You can change the maximum number of rows at any time.
| Caution: If you decrease the maximum number of rows, any data or formats in the rows beyond the new setting are lost. |
To increase the maximum number of rows when a row is inserted, first use the SSSetMaxRows function to increment the maximum number of rows by one, then use the SSInsRow function to insert the row.
Return Value
SSGetMaxRows: Maximum number of rows in the sheet.
See Also
Specifying the Maximum Number of Rows
Setting the Maximum Number of Columns and Rows
SSGetMaxCols, SSInsRow, SSSetMaxCols, SSSetSheet functions
ActiveX Correspondence
MaxRows property