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


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

    Parameters

    copyOptions
    Example
    This example uses the copy options.
    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)
            {
          fpSpread1.Sheets[0].ClipboardCopy(FarPoint.Win.Spread.ClipboardCopyOptions.AsStringSkipHidden);
             }
    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
            FpSpread1.Sheets(0).ClipboardCopy(FarPoint.Win.Spread.ClipboardCopyOptions.AsStringSkipHidden)
        End Sub
    See Also