Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / ClipboardCopy Method / ClipboardCopy(CellRange,ClipboardCopyOptions) Method
Example


In This Topic
    ClipboardCopy(CellRange,ClipboardCopyOptions) Method
    In This Topic
    Copies the contents from the specified CellRange in the sheet to the Clipboard using the specified ClipboardCopyOptions.
    Syntax
    'Declaration
     
    Public Overloads Sub ClipboardCopy( _
       ByVal cellRange As CellRange, _
       ByVal copyOptions As ClipboardCopyOptions _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim cellRange As CellRange
    Dim copyOptions As ClipboardCopyOptions
     
    instance.ClipboardCopy(cellRange, copyOptions)
    public void ClipboardCopy( 
       CellRange cellRange,
       ClipboardCopyOptions copyOptions
    )

    Parameters

    cellRange
    copyOptions
    Example
    This example copies data.
    private void Form1_Load(object sender, EventArgs e)
            {
           fpSpread1.Sheets[0].Cells[0, 0].Text = "test";
           fpSpread1.Sheets[0].Cells[0, 1].Text = "B";
           fpSpread1.Sheets[0].Cells[0, 2].Text = "C";
           fpSpread1.Sheets[0].Columns[1].Visible = false;          
            }
    
    private void button1_Click(object sender, EventArgs e)
            {
         FarPoint.Win.Spread.Model.CellRange cr = new FarPoint.Win.Spread.Model.CellRange(0, 0, 3, 3);
         fpSpread1.Sheets[0].ClipboardCopy(cr, FarPoint.Win.Spread.ClipboardCopyOptions.All);
             }
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            FpSpread1.Sheets(0).Cells(0, 0).Text = "test"
            FpSpread1.Sheets(0).Cells(0, 1).Text = "B"
            FpSpread1.Sheets(0).Cells(0, 2).Text = "C"
            FpSpread1.Sheets(0).Columns(1).Visible = False
        End Sub
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
            Dim cr As New FarPoint.Win.Spread.Model.CellRange(0, 0, 3, 3)
            FpSpread1.Sheets(0).ClipboardCopy(cr, FarPoint.Win.Spread.ClipboardCopyOptions.All)
        End Sub
    See Also