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


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

    Parameters

    cellRange
    Example
    This example copies a cell range.
    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);
             }
    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)
        End Sub
    See Also