Excel.Interfaces.FunctionResultLoadOptions interface

Package:

excel

An object containing the result of a function-evaluation operation

Remarks

[ API set: ExcelApi 1.2 ]

Properties

$all	Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: 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 LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: 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 ]