SSInsRow, SSInsRowRange Functions
Applies To
fpSpread DLL control
Description
Insert a row or multiple rows into the sheet before the specified row.
Syntax
BOOL SSInsRow(HWND hWnd, SS_COORD Row);
BOOL SSInsRowRange(HWND hWnd, SS_COORD Row, SS_COORD Row2);
BOOL TSpread::InsRow(SS_COORD Row);
BOOL TSpread::InsRowRange(SS_COORD Row, SS_COORD Row2);
Parameters
The following parameters are available:
| Parameter | Description |
| hWnd | Window handle of the fpSpread control |
| Row | Row number of row before which to insert new row or row number of first row in range to insert if using the SSInsRowRange function (Value must be greater than 0.) |
| Row2 | Row number of last row in range to insert if using the SSInsRowRange function |
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.
Use the SSInsRow function to insert a single row. Use the SSInsRowRange function to insert multiple rows.
When using the SSInsRowRange function, make sure that the value of the Row parameter is less than the value of the Row2 parameter.
Inserting rows beyond the last row containing data has no effect on the total number of rows.
The SSInsRow and SSInsRowRange functions do not increase the number of rows set by the SSSetMaxRows function. To increase the maximum number of rows when a row or rows are inserted, use the SSSetMaxRows function to increment the maximum number of rows by the number of rows being inserted before using the SSInsRow or SSInsRowRange function.
Return Value
TRUE if the function completes successfully; FALSE otherwise.
See Also
SSDelRow, SSDelRowRange, SSGetMaxRows, SSSetMaxRows, SSSetSheet functions
ActiveX Correspondence
SSInsRow: InsertRows method