Visual Basic (Declaration) | |
---|---|
Public Overloads Sub ClipboardPaste( _ ByVal pasteOption As ClipboardPasteOptions _ ) |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As SheetView Dim pasteOption As ClipboardPasteOptions instance.ClipboardPaste(pasteOption) |
C# | |
---|---|
public void ClipboardPaste( ClipboardPasteOptions pasteOption ) |
Parameters
- pasteOption
- Clipboard paste option (a setting of the ClipboardPasteOptions enumeration)
This example copies 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 copy the data to the clipboard?", "ClipboardCopy", MessageBoxButtons.YesNo); if (dlg == DialogResult.Yes) { fpSpread1.ActiveSheet.AddSelection(0, 0, 3, 3); fpSpread1.ActiveSheet.ClipboardCopy(); } dlg = MessageBox.Show("Do you want to paste the data from the clipboard? If yes, let's clear the data first.", "Clear", MessageBoxButtons.YesNo); if (dlg == DialogResult.Yes) { fpSpread1.ActiveSheet.Cells[0, 0, 5, 5].Text = ""; } dlg = MessageBox.Show("Now we're ready to paste!!", "ClipboardPaste", MessageBoxButtons.YesNo); if (dlg == DialogResult.Yes) { fpSpread1.ActiveSheet.ClipboardPaste(); } |
Visual Basic | Copy 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 copy the data to the clipboard?", "ClipboardCopy", MessageBoxButtons.YesNo) If dlg = DialogResult.Yes Then FpSpread1.ActiveSheet.AddSelection(0, 0, 3, 3) FpSpread1.ActiveSheet.ClipboardCopy() End If dlg = MessageBox.Show("Do you want to paste the data from the clipboard? If yes, let's clear the data first.", "Clear", MessageBoxButtons.YesNo) If dlg = DialogResult.Yes Then FpSpread1.ActiveSheet.Cells(0, 0, 5, 5).Text = "" End If dlg = MessageBox.Show("Now we're ready to paste!!", "ClipboardPaste", MessageBoxButtons.YesNo) If dlg = DialogResult.Yes Then FpSpread1.ActiveSheet.ClipboardPaste() End If |
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
Reference
SheetView ClassSheetView Members
Overload List
ClipboardPasteOptions Enum