Spread Windows Forms 7.0 Product Documentation
ClipboardCopy(CellRange) Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class > ClipboardCopy Method : ClipboardCopy(CellRange) Method


cellRange

Glossary Item Box

Copies the contents from the specified CellRange in the sheet to the Clipboard.

Syntax

Visual Basic (Declaration) 
Public Overloads Sub ClipboardCopy( _
   ByVal cellRange As CellRange _
) 
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim cellRange As CellRange
 
instance.ClipboardCopy(cellRange)
C# 
public void ClipboardCopy( 
   CellRange cellRange
)

Parameters

cellRange

Example

This example copies a cell range.
C#Copy Code
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);
         }
Visual BasicCopy Code
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

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.