.
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 |
|---|---|
| The page FunctionValue.Value does not exist. | |
| The page FunctionValue.Type does not exist. |
Constructors
Name | Description |
|---|---|
| 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. | |
| 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.True | A static FunctionValue representing true. |
| FunctionValue.False | A static FunctionValue representing false. |
| FunctionValue.Div0Error | Occurs when a number is divided either by zero (0) or by a cell that contains no value. |
| FunctionValue.ValueError | Occurs when incorrect value type was passed into a function. |
| FunctionValue.NameError | Occurs when text in a formula is not recognized. |
| FunctionValue.NumError | Occurs with invalid numeric values in a formula or function. |
| FunctionValue.NullError | Occurs when you specify an intersection of two areas that do not intersect. |
| FunctionValue.RefError | Occurs when a cell reference is not valid. |
| FunctionValue.NAError | Occurs when a value is not available to a function or formula. |