SwapRowRange Method
Applies To
fpSpread control
Description
Swaps the specified range of rows with another range of rows.
Syntax
void CSpreadSheet::SwapRowRange(long lRow, long lRow2, long lRowDest);
fpSpread1.SwapRowRange(ByVal lRow As Long, ByVal lRow2 As Long, ByVal lRowDest As Long)
Parameters
The following parameters are available:
| Parameter | Description |
|---|---|
| lRow | Row number of first row in range to swap |
| lRow2 | Row number of last row in range to swap |
| lRowDest | First row of range of rows to swap with rows specified by lRow and lRow2 parameters |
Remarks
Use the SwapRowRange method as a fast way to swap the data and formatting in a range of rows in the sheet. To swap a range of cells, use the SwapRange method. To swap a range of columns, use the SwapColRange method.
Swapping a range of rows using the SwapRowRange method swaps the data and formatting, including formulas and cell notes.
This method is called for the current sheet setting unless you first set the Sheet property to specify the sheet with which you want to work.
You can copy and move ranges of rows using the CopyRowRange and MoveRowRange methods.
Return Type
None
See Also
Sheet property
CopyColRange, CopyRowRange, MoveColRange, MoveRowRange, SwapColRange, SwapRange methods
DLL Correspondence
SSSwapRange function