SetFormula(Int32,Int32,StringBuilder) Method

Sets the specified cell to the specified formula.

[Visual Basic]
Overloads Overridable Sub SetFormula( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal buffer As StringBuilder _
) 

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

[C++]
virtual void SetFormula( 
   int row,
   int column,
   StringBuilder* buffer
) 

[C++/CLI]
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 NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

IValues Interface  | IValues Members  | Overload List  | GetFormula Method

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.