Sets a tab-delimited string that contains the unformatted text in a range.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As ColumnHeader
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 column header row index, or -1 for all column header rows
- column
- Starting column index, or -1 for all columns
- rowCount
- Number of column header rows, or -1 for all column header rows (may create new column header rows as needed)
- columnCount
- Number of columns, or -1 for all columns
- value
- Tab-delimited string to set into the range
Exceptions
Example
This example sets and returns a tab-delimited string containing the unformatted text from the column headers.
| C# | Copy Code |
|---|
fpSpread1.ActiveSheet.ColumnHeader.RowCount = 4;
fpSpread1.ActiveSheet.ColumnHeader.SetClipValue(0, 0, 2, 4, "one\ttwo\tthree\tfour\r\nfive\tsix\tseven\teight");
string s;
s = fpSpread1.ActiveSheet.ColumnHeader.GetClipValue(0, 0, 2, 4);
listBox1.Items.Add(s); |
| Visual Basic | Copy Code |
|---|
FpSpread1.ActiveSheet.ColumnHeader.RowCount = 4
FpSpread1.ActiveSheet.ColumnHeader.SetClipValue(0, 0, 2, 4, "one" + Chr(9) + "two" + Chr(9) + "three" + Chr(9) + "four" +
vbCrLf + "five" + Chr(9) + "six" + Chr(9) + "seven" + Chr(9) + "eight")
Dim s As String
s = FpSpread1.ActiveSheet.ColumnHeader.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
