Page tree
Skip to end of metadata
Go to start of metadata

Introduced in build 9.1

Description

The FunctionValue class is used to pass arguments in and get results from custom functions.
C#
vb.net

Examples

C#
vb.net

Properties

Name

Description

Value

The page FunctionValue.Value does not exist.

Type

The page FunctionValue.Type does not exist.

Constructors

Name

Description

FunctionValue(String)

Creates a new FunctionValue object setting the Value property to the String passed in to the constructor and setting the Type property to FunctionValueType.STRING.

FunctionValue(Boolean)

Creates a new FunctionValue object setting the Value property to the Boolean passed in to the constructor and setting the Type property to FunctionValueType.BOOLEAN.
FunctionValue(Double)Creates a new FunctionValue object setting the Value property to the Double passed in to the constructor and setting the Type property to FunctionValueType.NUMBER.
FunctionValue(Range)Creates a new FunctionValue object setting the Value property to the Range passed in to the constructor and setting the Type property to FunctionValueType.RANGE.

Values

Name

Description

FunctionValue.Null

A static FunctionValue representing null.
FunctionValue.TrueA static FunctionValue representing true.
FunctionValue.FalseA static FunctionValue representing false.
FunctionValue.Div0ErrorOccurs when a number is divided either by zero (0) or by a cell that contains no value.
FunctionValue.ValueErrorOccurs when incorrect value type was passed into a function.
FunctionValue.NameErrorOccurs when text in a formula is not recognized.
FunctionValue.NumErrorOccurs with invalid numeric values in a formula or function.
FunctionValue.NullErrorOccurs when you specify an intersection of two areas that do not intersect.
FunctionValue.RefErrorOccurs when a cell reference is not valid.
FunctionValue.NAErrorOccurs when a value is not available to a function or formula.
  • No labels