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 98, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0. SpreadsheetGear for .NET 2006 requires the Microsoft .NET Framework 2.0.

See Also