'Declaration
 
Public Sub SetFormula( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal value As String _
) 

'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim value As String
 
instance.SetFormula(row, column, value)

public void SetFormula( 
   int row,
   int column,
   string value
)

Parameters

row

Row index of the cell

column

Column index of the cell

value

Object that contains the formula for the cell

Set this property to a mathematical expression made up of cell references, operators, and functions (either provided or custom functions you define). For a list of the operators and functions you can use in formulas, refer to the Spread for .NET Formula Reference.

The Spread component can use absolute or relative cell references. You define the cell reference style for the spreadsheet by using the ReferenceStyle property. The formula cannot contain both absolute and relative row or column references.

The following table contains examples of valid formulas:

Reference

SheetView Class
SheetView Members
ReferenceStyle Field
Formula Property (Cell)
Formula Property (Column)
Formula Property (Row)
GetFormula Method

User-Task Documentation

Managing Formulas