Spread WPF 15
GrapeCity.Windows.SpreadSheet.Data Namespace / Worksheet Class / GetFormula(Int32,Int32) Method
The row index.
The column index.
Example


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

    Parameters

    row
    The row index.
    column
    The column index.

    Return Value

    Returns the formula string.
    Example
    This example uses the GetFormula method. 
    gcSpreadSheet1.Sheets[0].SetFormula(0, 0, "D1+D2");
gcSpreadSheet1.Sheets[0].SetFormula(1, 1, 2, 2, "E1+E1");
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetFormula(0, 0).ToString());
    GcSpreadSheet1.Sheets(0).SetFormula(0, 0, "D1+D2")
GcSpreadSheet1.Sheets(0).SetFormula(1, 1, 2, 2, "E1+E1")
ListBox1.Items.Add(gcSpreadSheet1.Sheets(0).GetFormula(0, 0).ToString())
    See Also

    Reference

    Worksheet Class
    Worksheet Members

     

     

    Copyright © 2022 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page