Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

Excel.Interfaces.FunctionResultLoadOptions interface

Package:
excel

An object containing the result of a function-evaluation operation

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


Feedback

Was this page helpful?