SpreadsheetGear The Performance Spreadsheet Component Company 
SetFormula(Int32,Int32,StringBuilder) Method
See Also 
SpreadsheetGear.Advanced.Cells Namespace > IValues Interface > SetFormula Method : SetFormula(Int32,Int32,StringBuilder) Method
row
Specifies the row of the cell to set.
column
Specifies the column of the cell to set.
buffer
Specifies the formula to place into the specified cell.
Sets the specified cell to the specified formula.

Syntax

C# 
virtual void SetFormula( 
   int row,
   int column,
   StringBuilder buffer
)

Parameters

row
Specifies the row of the cell to set.
column
Specifies the column of the cell to set.
buffer
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 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

Platforms: Windows Vista, Windows XP, Windows Server 2008, Windows Server 2003, Windows 2000, Windows Me and Windows 98, including 32 bit and 64 bit editions where applicable. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0 (works with .NET 3.x). SpreadsheetGear for .NET 2007 requires the Microsoft .NET Framework 2.0 (works with .NET 3.x).

See Also