SpreadsheetGear
SetFormula(Int32,Int32,StringBuilder) Method
See Also  Send Feedback
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

Visual Basic (Declaration) 
Overloads Sub SetFormula( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal buffer As StringBuilder _
) 
C# 
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 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

See Also

Copyright © 2003-2009 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.