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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
Reference
SheetView ClassSheetView Members
Overload List
ClipboardPasteOptions Enum