SpreadsheetGear 2017
CreateCommandPasteSpecial Method (CommandManager)






SpreadsheetGear.Commands Namespace > CommandManager Class : CreateCommandPasteSpecial Method
Specifies the range which this command will affect.
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.
Creates an instance of the default paste special command.
Syntax
'Declaration
 
Public Overridable Function CreateCommandPasteSpecial( _
   ByVal range As IRange, _
   ByVal pasteType As PasteType, _
   ByVal pasteOperation As PasteOperation, _
   ByVal skipBlanks As System.Boolean, _
   ByVal transpose As System.Boolean _
) As Command
'Usage
 
Dim instance As CommandManager
Dim range As IRange
Dim pasteType As PasteType
Dim pasteOperation As PasteOperation
Dim skipBlanks As System.Boolean
Dim transpose As System.Boolean
Dim value As Command
 
value = instance.CreateCommandPasteSpecial(range, pasteType, pasteOperation, skipBlanks, transpose)
public virtual Command CreateCommandPasteSpecial( 
   IRange range,
   PasteType pasteType,
   PasteOperation pasteOperation,
   System.bool skipBlanks,
   System.bool transpose
)
public function CreateCommandPasteSpecial( 
    range: IRange;
    pasteType: PasteType;
    pasteOperation: PasteOperation;
    skipBlanks: System.Boolean;
    transpose: System.Boolean
): Command; virtual; 
public function CreateCommandPasteSpecial( 
   range : IRange,
   pasteType : PasteType,
   pasteOperation : PasteOperation,
   skipBlanks : System.boolean,
   transpose : System.boolean
) : Command;
public: virtual Command* CreateCommandPasteSpecial( 
   IRange* range,
   PasteType pasteType,
   PasteOperation pasteOperation,
   System.bool skipBlanks,
   System.bool transpose
) 
public:
virtual Command^ CreateCommandPasteSpecial( 
   IRange^ range,
   PasteType pasteType,
   PasteOperation pasteOperation,
   System.bool skipBlanks,
   System.bool transpose
) 

Parameters

range
Specifies the range which this command will affect.
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
Override this method to provide a custom implementation of this command.
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

CommandManager Class
CommandManager Members