Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / ClipboardCut Method
Example


In This Topic
    ClipboardCut Method
    In This Topic
    Cuts the contents from the sheet to the Clipboard.
    Overload List
    OverloadDescription
    Cuts the contents from the sheet to the Clipboard.  
    Cuts the contents from specified range in the sheet to the Clipboard using the specified copy options.  
    Example
    This example cuts data to the clipboard.
    Random r = new Random();
    int i, j;
    DialogResult dlg;
    for (i = 0; i <= 3; i++)
    {
        for (j = 0; j <= 3; j++)
        {
            fpSpread1.ActiveSheet.SetValue(i, j, r.Next() -100000);
        }
    }
    dlg = MessageBox.Show("Do you want to cut the data to the clipboard?", "ClipboardCut", MessageBoxButtons.YesNo);
    if (dlg == DialogResult.Yes)
    {
        fpSpread1.ActiveSheet.AddSelection(0, 0, 3, 3);
        fpSpread1.ActiveSheet.ClipboardCut();
    }
    Dim r As New Random()
    Dim i, j As Integer
    Dim dlg As DialogResult
    For i = 0 To 3
        For j = 0 To 3
            FpSpread1.ActiveSheet.SetValue(i, j, r.Next - 100000.ToString())
        Next j
    Next i
    dlg = MessageBox.Show("Do you want to cut the data to the clipboard?", "ClipboardCut", MessageBoxButtons.YesNo)
    If dlg = DialogResult.Yes Then
        FpSpread1.ActiveSheet.AddSelection(0, 0, 3, 3)
        FpSpread1.ActiveSheet.ClipboardCut()
    End If
    See Also