SpreadsheetGear
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

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.