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

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.
    Public Overloads Sub ClipboardCopy( _
       ByVal cellRange As CellRange, _
       ByVal copyOptions As ClipboardCopyOptions _
    Dim instance As SheetView
    Dim cellRange As CellRange
    Dim copyOptions As ClipboardCopyOptions
    instance.ClipboardCopy(cellRange, copyOptions)
    public void ClipboardCopy( 
       CellRange cellRange,
       ClipboardCopyOptions copyOptions


    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