Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / RowHeader Class / SetClipValue Method
Starting row index, or -1 for all rows
Starting row header column index, or -1 for all row header columns
Number of rows, or -1 for all rows
Number of row header columns, or -1 for all row header columns (may create new row header columns as needed)
Tab-delimited string to set into the range
Example


In This Topic
    SetClipValue Method (RowHeader)
    In This Topic
    Sets a tab-delimited string that contains the unformatted text to a range.
    Syntax
    'Declaration
     
    Public Sub SetClipValue( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer, _
       ByVal value As String _
    ) 
    'Usage
     
    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)
    public void SetClipValue( 
       int row,
       int column,
       int rowCount,
       int columnCount,
       string 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
    ExceptionDescription
    Specified row index is out of range; must be between -1 and the total number of rows
    Specified column index is out of range; must be between -1 and the total number of columns
    Example
    This example gets a tab-delimited string containing the unformatted text from the row headers.
    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);
    
    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)
    See Also