Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / Worksheet Class / GetArrayFormula Method
The row index.
The column index.
The row count.
The column count.
Example


In This Topic
    GetArrayFormula Method
    In This Topic
    Gets the formula in the specified area in this sheet.
    Syntax
    'Declaration
     
    Public Function GetArrayFormula( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer _
    ) As String
    'Usage
     
    Dim instance As Worksheet
    Dim row As Integer
    Dim column As Integer
    Dim rowCount As Integer
    Dim columnCount As Integer
    Dim value As String
     
    value = instance.GetArrayFormula(row, column, rowCount, columnCount)
    public string GetArrayFormula( 
       int row,
       int column,
       int rowCount,
       int columnCount
    )

    Parameters

    row
    The row index.
    column
    The column index.
    rowCount
    The row count.
    columnCount
    The column count.

    Return Value

    Returns the formula string.
    Example
    This example uses the GetArrayFormula method.
    GcSpreadSheet1.Sheets[0].SetArrayFormula(0, 3, 4, 1, "B2:B5*C2:C5");
    TextBox1.Text = GcSpreadSheet1.Sheets[0].GetArrayFormula(0, 3, 4, 1).ToString();
    GcSpreadSheet1.Sheets(0).SetArrayFormula(0, 3, 4, 1, "B2:B5*C2:C5")
    TextBox1.Text = GcSpreadSheet1.Sheets(0).GetArrayFormula(0, 3, 4, 1).ToString()
    See Also