SwapRowRange Method

---

See Also    DLL    Example

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

Swapping Data

Sheet property

CopyColRange, CopyRowRange, MoveColRange, MoveRowRange, SwapColRange, SwapRange methods

DLL Correspondence

SSSwapRange function