SpreadsheetGear 2010
SetFormula(Int32,Int32,String) Method
See Also  Send Feedback
SpreadsheetGear.Advanced.Cells Namespace > IValues Interface > SetFormula Method : SetFormula(Int32,Int32,String) Method

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.
Sets the specified cell to the specified formula.

Syntax

Visual Basic (Declaration) 
Overloads Sub SetFormula( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal formula As String _
) 
C# 
void SetFormula( 
   int row,
   int column,
   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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

Copyright © 2003-2010 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.