Spread 8.0 Documentation
SwapRowRange Method
Support Options
ActiveX Reference > ActiveX Methods > SwapRowRange Method

Glossary Item Box

SwapRowRange Method


See Also    DLL    Example

Applies To

fpSpread control

Description

Swaps the specified range of rows with another range of rows.

Syntax

C++

void CSpreadSheet::SwapRowRange(long lRow, long lRow2, long lRowDest);

Visual Basic

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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.