Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Enum ClipboardCopyOptions Inherits System.Enum | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As ClipboardCopyOptions | |
| C# | |
|---|---|
public enum ClipboardCopyOptions : System.Enum | |
Members
| Member | Description |
|---|---|
| All | [0] Copies all data objects, including values, formatting, and formulas |
| AsString | [5] Copies as a text string |
| AsStringSkipHidden | [6] Copies as a text string and skips hidden cells |
| Formatting | [2] Copies only formatting |
| Formulas | [3] Copies only formulas |
| Values | [1] Copies only values |
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 Basic | Copy 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
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8