Spread Silverlight Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / ClipboardPasteOptions Enumeration
Example Example


In This Topic
    ClipboardPasteOptions Enumeration
    In This Topic
    Specifies what data is pasted from the Clipboard.
    Syntax
    'Declaration
     
    <FlagsAttribute()>
    Public Enum ClipboardPasteOptions 
       Inherits System.Enum
    'Usage
     
    Dim instance As ClipboardPasteOptions
    [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 sets 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