Gets a tab-delimited string containing the unformatted text in a range.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As RowHeader
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim value As String
value = instance.GetClipValue(row, column, rowCount, columnCount) |
Parameters
- row
- Starting row index, or -1 for all rows
- column
- Starting row header column index, or -1 for all row header columns
- rowCount
- Number of rows, or -1 for all rows
- columnCount
- Number of row header columns, or -1 for all row header columns
Return Value
Tab-delimited
String containing the unformatted data in the range
Exceptions
Example
This example gets a tab-delimited string containing the unformatted text from the row headers.
| Visual Basic | Copy Code |
|---|
Dim r As FarPoint.Win.Spread.RowHeader
Dim s As String
r = FpSpread1.ActiveSheet.RowHeader
r.ColumnCount = 6
r.SetClipValue(0, 0, 2, 4, "1" + Chr(9) + "2" + Chr(9) + "3" + Chr(9) + "4" + vbCrLf + "5" + Chr(9) + "6" + Chr(9) + "7" +
Chr(9) + "8")
s = r.GetClipValue(0, 0, 2, 4)
ListBox1.Items.Add(s) |
| C# | Copy Code |
|---|
FarPoint.Win.Spread.RowHeader r;
string s;
r = fpSpread1.ActiveSheet.RowHeader;
r.ColumnCount = 6;
r.SetClipValue(0, 0, 2, 4, "1\t2\t3\t4\r\n5\t6\t7\t8");
s = r.GetClipValue(0, 0, 2, 4);
listBox1.Items.Add(s); |
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
See Also
