Spread WPF Documentation
Spread WPF Documentation / Developer's Guide / Managing the User Interface / Using Clipboard Operations
In This Topic
    Using Clipboard Operations
    In This Topic

    The user can cut, copy, and paste data in the control by default. You can set AutoClipboard to false to prevent this. The ClipBoardOptions property allows you to control what data is pasted by the user. If the user cuts the data before pasting, all the information is pasted.

    The cut action is treated as a copy action if the user cuts the data between controls, between the control and an Excel-formatted file, or between the GcSpreadSpread control and other controls.

    Copying and pasting between the control and a CSV file is only supported if the text is separated with /t.

    The following conditions apply when using cut, copy, or paste:

    Using Code

    The following example copies and pastes data using the ClipboardCopy and ClipboardPaste methods.

    CS
    Copy Code

    gcSpreadSheet1.AutoClipboard = true;
    gcSpreadSheet1.ClipBoardOptions = GrapeCity.Windows.SpreadSheet.Data.ClipboardPasteOptions.All;
    gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = "Copy";
    gcSpreadSheet1.Sheets[0].Cells[1, 1].Value = "Cut";
    gcSpreadSheet1.Invalidate();

    private void button1_Click(object sender, RoutedEventArgs e)
      {
            GrapeCity.Windows.SpreadSheet.Data.CellRange r;
           r = new  GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 2, 2);
           GrapeCity.Windows.SpreadSheet.Data.CellRange r2;
           r2 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(3, 3, 2, 2);
           GrapeCity.Windows.SpreadSheet.UI.GcSpreadSheet test;
           
           test = gcSpreadSheet1;
           test.View.ClipboardCopy(r);
           //test.View.ClipboardCut(r);
           test.View.ClipboardPaste(r2);
           gcSpreadSheet1.Invalidate();
       }

    VB.NET
    Copy Code
    GcSpreadSheet1.AutoClipboard = True
    GcSpreadSheet1.ClipBoardOptions = GrapeCity.Windows.SpreadSheet.Data.ClipboardPasteOptions.All
    GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = "Copy"
    GcSpreadSheet1.Sheets(0).Cells(1, 1).Value = "Cut"
    GcSpreadSheet1.Invalidate()
     
        Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
            Dim r As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 2, 2)
            Dim r2 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(3, 3, 2, 2)
            Dim test = GcSpreadSheet1
            test.View.ClipboardCopy(r)
            'test.View.ClipboardCut(r)
            test.View.ClipboardPaste(r2)
            GcSpreadSheet1.Invalidate()
        End Sub
    See Also