Sets a tab-delimited string containing 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 formatted text from the column headers.
| C# | Copy Code |
|---|
FpSpread1.ActiveSheetView.ColumnHeader.RowCount = 4;
FpSpread1.ActiveSheetView.ColumnHeader.SetClipValue(0, 0, 2, 4, "one\ttwo\tthree\tfour\r\nfive\tsix\tseven\teight");
string s;
s = FpSpread1.ActiveSheetView.ColumnHeader.GetClipValue(0, 0, 2, 4);
ListBox1.Items.Add(s);
|
| Visual Basic | Copy Code |
|---|
FpSpread1.ActiveSheetView.ColumnHeader.RowCount = 4
FpSpread1.ActiveSheetView.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.ActiveSheetView.ColumnHeader.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
