'Declaration
 
Public MustOverride Sub Evaluate( _
   ByVal arguments As IArguments, _
   ByVal result As IValue _
) 

'Usage
 
Dim instance As Function
Dim arguments As IArguments
Dim result As IValue
 
instance.Evaluate(arguments, result)

public abstract void Evaluate( 
   IArguments arguments,
   IValue result
)

Parameters

arguments

Provides access to the arguments to this custom function. Note that using the IArguments indexer has the side effect of converting a range reference or array to a simple value (use GetArrayDimensions and GetArrayValue to get individual values from a range or array).

result

Assign the result of the custom function to result. The value of result is undefined until set by the Evaluate method.

The implementation of this method must follow a number of rules:

• The method must be thread safe. Some versions of SpreadsheetGear call this method from multiple threads at the same time.
• The method must not use any API in the workbook set which is being calculated except for IArguments.CurrentWorksheet.Name, IArguments.CurrentWorksheet.Index, IArguments.CurrentWorksheet.Workbook.Name, IArguments.CurrentWorksheet.Workbook.DateTimeToNumber or IArguments.CurrentWorksheet.Workbook.NumberToDateTime.
• All access to cells must be through arguments.
• Accessing the IArguments indexer has the side effect of converting references to ranges or arrays to a single simple value. Use IArguments.GetArrayDimensions and IArguments.GetArrayValue to access the individual values of a range or array. For example, if the first custom function argument is the range A1:C3, setting a watch on arguments[0] in a debugger will convert this range to a single simple value.
• No references to interfaces or objects passed to, or acquired during the execution of this method should be used after this method completes execution.

If an exception is thrown during custom function evaluation, the custom function will return ValueError.Name.

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

Function Class
Function Members