Link Search Menu Expand Document

SSpread.CopyRowRange Method

Explanation Copies the specified row range to the specified position.

The row range data and formatting are copied. The copy destination row will be overwritten with the same number of rows as the row range to be copied.

Use the CopyRange method to copy a range of cells and the CopyColRange method to copy a range of columns. You can move or swap row ranges using the MoveRowRange and SwapRowRange methods.
Call format CopyRowRange(row, row2, rowdest)
Return value None
Arguments row The last row number of the row range to copy
row2 Row number to copy to the row range
rowdest Row number to copy to the row range
Exception EXT-28 An error occurred in the CopyRowRange method
Example of use
    BlockMode = $TRUE;
    Col = 2;
    Row = 2;
    Col2 = 4;
    Row2 = 4;
    Text = "sample";
    BackColor = $GREEN;
    BlockMode = $FALSE;
    
    CopyRowRange(2, 3, 6);
    
Related item CopyColRange, CopyRange, MoveColRange, MoveRowRange, SwapColRange, SwapRowRange methods