CopyRange Method

Copies the data, formatting, formulas, and notes from a block of cells on the sheet to a new location.

Overload List

Overload	Description
CopyRange	Copies the data, formatting, formulas, and notes from a block of cells on the sheet to a new location.

Example

This example copies the data in a range of cells.

fpSpread1.ActiveSheet.Cells[0, 0, 1, 1].Text = "Copy";
fpSpread1.ActiveSheet.CopyRange(0, 0, 3, 0, 1, 1, true);

Visual Basic

FpSpread1.ActiveSheet.Cells(0, 0, 1, 1).Text = "Copy"
FpSpread1.ActiveSheet.CopyRange(0, 0, 3, 0, 1, 1, True)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

SheetView Class
SheetView Members

User-Task Documentation

Creating a Range of Cells