SpreadsheetGear 2023
PasteType Enumeration


SpreadsheetGear Namespace : PasteType Enumeration
Specifies what is copied by IRange.Copy.
Syntax
'Declaration
 
Public Enum PasteType 
   Inherits System.Enum
'Usage
 
Dim instance As PasteType
public enum PasteType : System.Enum 
Members
MemberDescription
AllCopies all formulas, values and formatting.
AllExceptBordersCopies all formulas, values and formatting except cell borders.
ColumnWidthsCopies column widths.
CommentsCopies comments.
FormatsCopies formats, but no formulas or values.
FormulasCopies formulas and values, but no formats.
FormulasAndNumberFormatsCopies formulas, values and number formats, but no other formatting.
ValidationCopies validation.
ValuesCopies values, but no formulas or formats.
ValuesAndNumberFormatsCopies values and number formats, but no formulas or other formats.
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         SpreadsheetGear.PasteType

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

SpreadsheetGear Namespace