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 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