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


In This Topic
    FindFormulas Method
    In This Topic
    Gets formulas in the specified area.
    Syntax
    'Declaration
     
    Public Function FindFormulas( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer _
    ) As Object(,)
    'Usage
     
    Dim instance As Worksheet
    Dim row As Integer
    Dim column As Integer
    Dim rowCount As Integer
    Dim columnCount As Integer
    Dim value() As Object
     
    value = instance.FindFormulas(row, column, rowCount, columnCount)
    public object[,] FindFormulas( 
       int row,
       int column,
       int rowCount,
       int columnCount
    )

    Parameters

    row
    The start row.
    column
    The start column.
    rowCount
    The row count.
    columnCount
    The column count.

    Return Value

    Two dimensional array. The first dimension saves the cell range and the second dimension saves the formula related to the cell range.
    Example
    This example uses the FindFormulas method.
    Object[,] arr;
    gcSpreadSheet1.Sheets[0].Cells[1, 1].Formula = "D1+E1";
    arr = gcSpreadSheet1.Sheets[0].FindFormulas(0, 0, 2, 2);
    listBox1.Items.Add(arr[0, 0].ToString());
    Dim arr As [Object](,)
    GcSpreadSheet1.Sheets(0).Cells(1, 1).Formula = "D1+E1"
    arr = GcSpreadSheet1.Sheets(0).FindFormulas(0, 0, 2, 2)
    ListBox1.Items.Add(arr(0, 0).ToString())
    See Also