Calculates a custom function returning a FunctionValue given a list of ComputationResult arguments and the function's current Cell for context.

ComputationResult CustomFunction(IList<ComputationResult> args, Cell currentCell)

Function CustomFunction(IList<ComputationResult> args, Cell currentCell) As ComputationResult

An ordered list of FunctionValue arguments that have already been fully evaluated.

The Cell that the current function resides in to use for context sensitive operations

A ComputationResult that contains the resulting value of the function.

 

 

    public ComputationResult CustomFunction(IList<ComputationResult> args, Cell currentCell)
    {
        StringBuilder result = new StringBuilder("");
 
 
        foreach (ComputationResult arg in args)
            if (arg.Type != ComputationResultType.RANGE)
                result.Append(arg);
 
 
        return new ComputationResult(result.ToString());
    }
    Public Function CustomFunction(args As IList(Of ComputationResult), currentCell As Cell) As ComputationResult
        Dim result As New StringBuilder("")
        For Each arg As ComputationResult In args
            If arg.Type <> ComputationResultType.RANGE Then
                result.Append(arg)
            End If
        Next
        Return New ComputationResult(result.ToString())
    End Function