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