GetFormula Method (SheetView)

Gets the formula of the specified cell on this sheet.

Overload List

Overload	Description
GetFormula	Gets the formula of the specified cell on this sheet.

Remarks

For more information on formulas, refer to the Formula Reference.

Example

This example illustrates the use of this member by returning the formula for the specified cell.

fpSpread1.ActiveSheet.Cells[0, 0, 1, 1].Value = 20;
fpSpread1.ActiveSheet.SetFormula(2, 0, "Sum(A1,B1)"); 
object o;
o = fpSpread1.ActiveSheet.GetFormula(2, 0);
listBox1.Items.Add(o.ToString());

Visual Basic

FpSpread1.ActiveSheet.Cells(0, 0, 1, 1).Value = 20
FpSpread1.ActiveSheet.SetFormula(2, 0, "Sum(A1,B1)")
Dim o As Object
o = FpSpread1.ActiveSheet.GetFormula(2, 0)
ListBox1.Items.Add(o.ToString())

Reference

SheetView Class
SheetView Members

User-Task Documentation

Managing Formulas in Cells

Product Support Forum | Print this page