Introducedin | ||
---|---|---|
|
Description |
---|
Excerpt |
---|
The FunctionValue class is used to pass arguments in and get results from custom functions. |
...
Constructors |
---|
Name | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
FunctionValue(stringString) | Creates a new FunctionValue with the Type set to STRING | ||||||||
FunctionValue(bool) | Creates a new FunctionValue with the Type set to BOOLEAN | ||||||||
FunctionValue(double) | Creates a new FunctionValue with the Type set to NUMBER | ||||||||
FunctionValue(Range) | Creates a new FunctionValue with the Type set to RANGE
| ||||||||
| |||||||||
FunctionValue(Double) |
| ||||||||
FunctionValue(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. |