SpreadsheetGear 2010
PasteSpecial Method
See Also  Send Feedback
SpreadsheetGear.Windows.Forms Namespace > WorkbookView Class : PasteSpecial Method

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.
Paste the clipboard contents to the current selection using the specified options.

Syntax

Visual Basic (Declaration) 
Public Sub PasteSpecial( _
   ByVal pasteType As PasteType, _
   ByVal pasteOperation As PasteOperation, _
   ByVal skipBlanks As Boolean, _
   ByVal transpose As Boolean _
) 
C# 
public void PasteSpecial( 
   PasteType pasteType,
   PasteOperation pasteOperation,
   bool skipBlanks,
   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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

Copyright © 2003-2010 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.