SpreadsheetGear 2017
PasteSpecial Method (WorkbookView)






SpreadsheetGear.Windows.Controls Namespace > WorkbookView Class : PasteSpecial Method
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.
Paste the clipboard contents to the current selection using the specified options.
Syntax
'Declaration
 
Public Sub PasteSpecial( _
   ByVal pasteType As PasteType, _
   ByVal pasteOperation As PasteOperation, _
   ByVal skipBlanks As System.Boolean, _
   ByVal transpose As System.Boolean _
) 
'Usage
 
Dim instance As WorkbookView
Dim pasteType As PasteType
Dim pasteOperation As PasteOperation
Dim skipBlanks As System.Boolean
Dim transpose As System.Boolean
 
instance.PasteSpecial(pasteType, pasteOperation, skipBlanks, transpose)
public void PasteSpecial( 
   PasteType pasteType,
   PasteOperation pasteOperation,
   System.bool skipBlanks,
   System.bool transpose
)
public procedure PasteSpecial( 
    pasteType: PasteType;
    pasteOperation: PasteOperation;
    skipBlanks: System.Boolean;
    transpose: System.Boolean
); 
public function PasteSpecial( 
   pasteType : PasteType,
   pasteOperation : PasteOperation,
   skipBlanks : System.boolean,
   transpose : System.boolean
);
public: void PasteSpecial( 
   PasteType pasteType,
   PasteOperation pasteOperation,
   System.bool skipBlanks,
   System.bool transpose
) 
public:
void PasteSpecial( 
   PasteType pasteType,
   PasteOperation pasteOperation,
   System.bool skipBlanks,
   System.bool transpose
) 

Parameters

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

WorkbookView Class
WorkbookView Members