FarPoint.Win.Spread
ClipboardCopyOptions Enumeration
Example  See Also 
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace : ClipboardCopyOptions Enumeration


Specifies what data is pasted from the Clipboard.

Syntax

Visual Basic (Declaration) 
Public Enum ClipboardCopyOptions 
   Inherits Enum
Visual Basic (Usage)Copy Code
Dim instance As ClipboardCopyOptions
C# 
public enum ClipboardCopyOptions : Enum

Members

MemberDescription
All [0] Copies all data objects, including values, formatting, and formulas
Values [1] Copies only values
Formatting [2] Copies only formatting
Formulas [3] Copies only formulas
AsString [5] Copies as a text string
AsStringSkipHidden [6] Copies as a text string and skips hidden cells

Example

This example uses the ClipboardCopyOptions enumeration.
C#Copy Code
private void Form1_Load(object sender, EventArgs e)
       {
      fpSpread1.Sheets[0].Cells[0, 0].Text = "test";
      fpSpread1.Sheets[0].Cells[0, 1].Text = "B";
      fpSpread1.Sheets[0].Cells[0, 2].Text = "C";
      fpSpread1.Sheets[0].Columns[1].Visible = false;          
       }

private void button1_Click(object sender, EventArgs e)
       {
     fpSpread1.Sheets[0].ClipboardCopy(FarPoint.Win.Spread.ClipboardCopyOptions.AsStringSkipHidden);
        }
Visual BasicCopy Code
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        FpSpread1.Sheets(0).Cells(0, 0).Text = "test"
        FpSpread1.Sheets(0).Cells(0, 1).Text = "B"
        FpSpread1.Sheets(0).Cells(0, 2).Text = "C"
        FpSpread1.Sheets(0).Columns(1).Visible = False
    End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        FpSpread1.Sheets(0).ClipboardCopy(FarPoint.Win.Spread.ClipboardCopyOptions.AsStringSkipHidden)
    End Sub

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.ClipboardCopyOptions

See Also