AddFormula Method

Adds or updates the control formula.

Syntax

Visual Basic
C#

'Declaration
 
Public Sub AddFormula( _
   ByVal controlId As String, _
   ByVal formula As String _
)

'Usage
 
Dim instance As FormulaExtender
Dim controlId As String
Dim formula As String
 
instance.AddFormula(controlId, formula)

public void AddFormula( 
   string controlId,
   string formula
)

Parameters

controlId: The control ID (server side only)
formula: The formula

Example

This example displays a cell value in a text box.

FpSpread1.ActiveSheetView.Cells[0, 0].Value = 2;
FpSpread1.ActiveSheetView.Cells[1, 0].Value = 3;
FormulaExtender1.AddFormula("textBox2", "[FpSpread1]Sheet1!A2");

Visual Basic

FpSpread1.ActiveSheetView.Cells(0, 0).Value = 2
FpSpread1.ActiveSheetView.Cells(1, 0).Value = 3
FormulaExtender1.AddFormula("textBox2", "[FpSpread1]Sheet1!A2")

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

FormulaExtender Class
FormulaExtender Members