SpreadsheetGear 2010
EvaluateValue Method
See Also  Send Feedback
SpreadsheetGear Namespace > ISheet Interface : EvaluateValue Method

formula
The formula to evaluate.
Evaluates the specified formula and returns the result as a System.Double, System.String, System.Boolean or ValueError.

Syntax

Visual Basic (Declaration) 
Function EvaluateValue( _
   ByVal formula As String _
) As Object
C# 
object EvaluateValue( 
   string formula
)

Parameters

formula
The formula to evaluate.

Return Value

The result of evaluating the formula as a System.Double, System.String, System.Boolean or ValueError.

Remarks

null will be returned if the formula is invalid.

If the formula results in a range or an array, the top-left value of the range or array will be returned.

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.