SpreadsheetGear 2023
SetFormula(Int32,Int32,String) Method


SpreadsheetGear.Advanced.Cells Namespace > IValues Interface > SetFormula Method : SetFormula(Int32,Int32,String) Method
Specifies the row of the cell to set.
Specifies the column of the cell to set.
Specifies the formula to place into the specified cell.
Sets the specified cell to the specified formula.
Syntax
'Declaration
 
Overloads Sub SetFormula( _
   ByVal row As System.Integer, _
   ByVal column As System.Integer, _
   ByVal formula As System.String _
) 
'Usage
 
Dim instance As IValues
Dim row As System.Integer
Dim column As System.Integer
Dim formula As System.String
 
instance.SetFormula(row, column, formula)
void SetFormula( 
   System.int row,
   System.int column,
   System.string formula
)

Parameters

row
Specifies the row of the cell to set.
column
Specifies the column of the cell to set.
formula
Specifies the formula to place into the specified cell.
Remarks

See the IValues overview for warnings about using this method.

The specified formula must be a valid cell formula. A leading "=" is optional.

Note that, unlike SpreadsheetGear.IRange.Formula, this method does not try to parse the value as anything but a valid formula, and an ArgumentException will be thrown if the formula is invalid.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

IValues Interface
IValues Members
Overload List
Formula Property