Sets a tab-delimited string that contains the unformatted text to 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
instance.SetClipValue(row, column, rowCount, columnCount, value) |
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 (may create new row header columns as needed)
- value
- Tab-delimited string to set into 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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also