Spread WPF Documentation
ClipboardPasteOptions Enumeration
Example Example 


GrapeCity.Windows.SpreadSheet.Data Namespace : ClipboardPasteOptions Enumeration
Specifies what data is pasted from the Clipboard.
Syntax
'Declaration
 
<System.FlagsAttribute()>
Public Enum ClipboardPasteOptions 
   Inherits System.Enum
'Usage
 
Dim instance As ClipboardPasteOptions
[System.Flags()]
public enum ClipboardPasteOptions : System.Enum 
Members
MemberDescription
All[0] Pastes all data objects, including values, formatting, and formulas.
FloatingObjectsThe floating objects
Formatting[2] Pastes only formatting.
Formulas[3] Pastes only formulas.
RangeGroupThe range group
SpanIndicates to copy a span.
SparklineIndicates the type of data is a sparkline.
TagsThe tags
Values[1] Pastes only values.
Example
This example uses the ClipboardPasteOptions enumeration.
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();
   }
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
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Windows.SpreadSheet.Data.ClipboardPasteOptions

See Also

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace