Sets 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
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.
| C# | Copy Code |
|---|
FarPoint.Web.Spread.RowHeader r;
string s;
r = FpSpread1.ActiveSheetView.RowHeader;
r.ColumnCount = 6;
r.SetClip(0, 0, 2, 4, "1\t2\t3\t4\r\n5\t6\t7\t8");
s = r.GetClipValue(0, 0, 2, 4);
ListBox1.Items.Add(s);
|
| Visual Basic | Copy Code |
|---|
Dim r As FarPoint.Web.Spread.RowHeader
Dim s As String
r = FpSpread1.ActiveSheetView.RowHeader
r.ColumnCount = 6
r.SetClip(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) |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
