Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / Cell Class / CopyAndPasteTo Method
Where the data will be pasted; this can be either an Address (ie. "D14") or a RowID followed by a ColumnID (ie. 4, 5).
The PasteOptions; in other words, this determines what will be pasted into the new Cell.
The CopyOptions; in other words, this determines if the Cell will be copied or cut. 
Example


In This Topic
    CopyAndPasteTo Method (Cell)
    In This Topic
    Copies or cuts a Cell & pastes it into another Cell.
    Syntax
    'Declaration
     
    
    Public Sub CopyAndPasteTo( _
       ByVal to As Cell, _
       Optional ByVal pasteOptions As PasteOptions, _
       Optional ByVal copyOptions As CopyOptions _
    ) 
    'Usage
     
    
    Dim instance As Cell
    Dim to As Cell
    Dim pasteOptions As PasteOptions
    Dim copyOptions As CopyOptions
     
    instance.CopyAndPasteTo(to, pasteOptions, copyOptions)
    public void CopyAndPasteTo( 
       Cell to,
       PasteOptions pasteOptions,
       CopyOptions copyOptions
    )

    Parameters

    to
    Where the data will be pasted; this can be either an Address (ie. "D14") or a RowID followed by a ColumnID (ie. 4, 5).
    pasteOptions
    The PasteOptions; in other words, this determines what will be pasted into the new Cell.
    copyOptions
    The CopyOptions; in other words, this determines if the Cell will be copied or cut. 
    Example
    // Copies Cell A1 to Cell A12.
    worksheet.Cells[ "A1" ].CopyAndPasteTo( worksheet.Cells[ "A12" ] );
    Requirements

    Target Platforms: Windows 11, Windows 10, 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