FarPoint.Win.Spread
ClipboardCut Method
See Also  Example
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : ClipboardCut Method


Overload List

OverloadDescription
ClipboardCut() Cuts the contents from the sheet to the Clipboard.  
ClipboardCut(ClipboardCopyOptions) 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.
C#Copy Code
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();
}
Visual BasicCopy Code
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