SpreadsheetGear 2023
CommandRange.PasteSpecial Constructor


SpreadsheetGear.Commands Namespace > CommandRange.PasteSpecial Class : CommandRange.PasteSpecial Constructor
Specifies the range for this command to operate on.
Specifies what to paste.
Specifies how to combine values.
Specifies whether blanks in the source range should be skipped (formatted cells with no data are considered blank cells).
Specifies whether data should be transposed in the destination.
Initializes this Command with the specified IRange and paste special options.
Syntax
'Declaration
 
Public Function New( _
   ByVal range As IRange, _
   ByVal pasteType As PasteType, _
   ByVal pasteOperation As PasteOperation, _
   ByVal skipBlanks As System.Boolean, _
   ByVal transpose As System.Boolean _
)
'Usage
 
Dim range As IRange
Dim pasteType As PasteType
Dim pasteOperation As PasteOperation
Dim skipBlanks As System.Boolean
Dim transpose As System.Boolean
 
Dim instance As New CommandRange.PasteSpecial(range, pasteType, pasteOperation, skipBlanks, transpose)
public CommandRange.PasteSpecial( 
   IRange range,
   PasteType pasteType,
   PasteOperation pasteOperation,
   System.bool skipBlanks,
   System.bool transpose
)

Parameters

range
Specifies the range for this command to operate on.
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.
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

CommandRange.PasteSpecial Class
CommandRange.PasteSpecial Members