Excel.Interfaces.FunctionResultLoadOptions interface

An object containing the result of a function-evaluation operation

Remarks

[ API set: ExcelApi 1.2 ]

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

error

Error value (such as "#DIV/0") representing the error. If the error string is not set, then the function succeeded, and its result is written to the Value field. The error is always in the English locale.

value

The value of function evaluation. The value field will be populated only if no error has occurred (i.e., the Error property is not set).

Property Details

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

error

Error value (such as "#DIV/0") representing the error. If the error string is not set, then the function succeeded, and its result is written to the Value field. The error is always in the English locale.

error?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

value

The value of function evaluation. The value field will be populated only if no error has occurred (i.e., the Error property is not set).

value?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]