SpreadsheetGear
Copy(IRange,PasteType,PasteOperation,Boolean,Boolean) Method
See Also  Send Feedback
SpreadsheetGear Namespace > IRange Interface > Copy Method : Copy(IRange,PasteType,PasteOperation,Boolean,Boolean) Method

destination
The destination range.
pasteType
Specifies what to paste.
pasteOperation
Specifies how to combine values.
skipBlanks
Specifies whether blanks in the source range should be skipped (formatted cells with no data are considered blank cells).
transpose
Specifies whether data should be transposed in the destination.
Copies the cells, rows and/or columns of the current IRange to the destination IRange using the specified options.

Syntax

Visual Basic (Declaration) 
Overloads Sub Copy( _
   ByVal destination As IRange, _
   ByVal pasteType As PasteType, _
   ByVal pasteOperation As PasteOperation, _
   ByVal skipBlanks As Boolean, _
   ByVal transpose As Boolean _
) 
C# 
void Copy( 
   IRange destination,
   PasteType pasteType,
   PasteOperation pasteOperation,
   bool skipBlanks,
   bool transpose
)

Parameters

destination
The destination range.
pasteType
Specifies what to paste.
pasteOperation
Specifies how to combine values.
skipBlanks
Specifies whether blanks in the source range should be skipped (formatted cells with no data are considered blank cells).
transpose
Specifies whether data should be transposed in the destination.

Remarks

Column widths, column formats and column outlines are copied if entire columns are being copied.

Row heights, row formats and row outlines are copied if entire rows are being copied.

Requirements

Platforms: x86 and x64 versions of Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server 2003 (including R2) and Windows Server 2008 (including R2). SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

See Also

Copyright © 2003-2009 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.