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 ColumnFooter 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 footer row index, or -1 for all column footer rows
- column
- Starting column index, or -1 for all columns
- rowCount
- Number of column footer rows, or -1 for all column footer rows (may create new column footer 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 |
Example
This example uses the SetClip method.
| C# | Copy Code |
|---|---|
FpSpread1.ActiveSheetView.ColumnFooter.Visible = true; FpSpread1.ActiveSheetView.ColumnFooter.RowCount = 2; FpSpread1.ActiveSheetView.ColumnFooter.SetClip(0, 0, 2, 4, "one\ttwo\tthree\tfour\r\nfive\tsix\tseven\teight"); | |
| VB.NET | Copy Code |
|---|---|
FpSpread1.ActiveSheetView.ColumnFooter.Visible = True FpSpread1.ActiveSheetView.ColumnFooter.RowCount = 2 FpSpread1.ActiveSheetView.ColumnFooter.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") | |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6