Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Sub SetClip( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal rowCount As Integer, _ ByVal columnCount As Integer, _ ByVal value As String _ ) | |
| 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.SetClip(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
| Exception | Description |
|---|---|
| System.ArgumentOutOfRangeException | Specified row index is out of range; must be between -1 and the total number of rows |
| System.ArgumentOutOfRangeException | Specified column index is out of range; must be between -1 and the total number of columns |
Remarks
The data in the range is formatted using the composite style for the cell in the column header style model.
Example
This example sets and returns a tab-delimited string containing the formatted text from the column headers.
| C# | Copy Code |
|---|---|
fpSpread1.ActiveSheet.ColumnHeader.RowCount = 4; fpSpread1.ActiveSheet.ColumnHeader.SetClip(0, 0, 2, 4, "one\ttwo\tthree\tfour\r\nfive\tsix\tseven\teight"); string s; s = fpSpread1.ActiveSheet.ColumnHeader.GetClip(0, 0, 2, 4); listBox1.Items.Add(s); | |
| Visual Basic | Copy Code |
|---|---|
FpSpread1.ActiveSheet.ColumnHeader.RowCount = 4 FpSpread1.ActiveSheet.ColumnHeader.SetClip(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.GetClip(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