Spread WPF 14
GrapeCity.Windows.SpreadSheet.Data Namespace / Worksheet Class / SetArrayFormula Method
The start row index.
The start column index.
The number of rows in all areas.
The number of columns in all areas.
The formula to place in the specified cell.
Example


In This Topic
    SetArrayFormula Method (Worksheet)
    In This Topic
    Sets an array formula in a specified cell area in the specified sheet area.
    Syntax
    'Declaration
     
    Public Sub SetArrayFormula( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer, _
       ByVal formula As String _
    ) 
    'Usage
     
    Dim instance As Worksheet
    Dim row As Integer
    Dim column As Integer
    Dim rowCount As Integer
    Dim columnCount As Integer
    Dim formula As String
     
    instance.SetArrayFormula(row, column, rowCount, columnCount, formula)
    public void SetArrayFormula( 
       int row,
       int column,
       int rowCount,
       int columnCount,
       string formula
    )

    Parameters

    row
    The start row index.
    column
    The start column index.
    rowCount
    The number of rows in all areas.
    columnCount
    The number of columns in all areas.
    formula
    The formula to place in the specified cell.
    Example
    This example uses the SetArrayFormula method.
    gcSpreadSheet1.Sheets[0].SetArrayFormula(0, 3, 4, 1, "B2:B5*C2:C5");
    gcSpreadSheet1.Sheets(0).SetArrayFormula(0, 3, 4, 1, "B2:B5*C2:C5")
    See Also