Edit

Excel.BusyErrorCellValue interface

Represents the value of a cell containing a #BUSY! error.

Properties

basicType

Represents the value that would be returned by Range.valueTypes for a cell with this value.

basicValue

Represents the value that would be returned by Range.values for a cell with this value. When accessed through a valuesAsJson property, this string value aligns with the en-US locale. When accessed through a valuesAsJsonLocal property, this string value aligns with the user's display locale.

errorSubType

Represents the type of BusyErrorCellValue.

errorType

Represents the type of ErrorCellValue.

previousValue

Optionally, a #BUSY! error may store the previous value stored in the cell, before the current transient operation began.

type

Represents the type of this cell value.

Property Details

basicType

Represents the value that would be returned by Range.valueTypes for a cell with this value.

basicType?: RangeValueType.error | "Error";

Property Value

error | "Error"

Remarks

API set: ExcelApi 1.16

basicValue

Represents the value that would be returned by Range.values for a cell with this value. When accessed through a valuesAsJson property, this string value aligns with the en-US locale. When accessed through a valuesAsJsonLocal property, this string value aligns with the user's display locale.

basicValue?: "#BUSY!" | string;

Property Value

"#BUSY!" | string

Remarks

API set: ExcelApi 1.16

errorSubType

Represents the type of BusyErrorCellValue.

errorSubType?: BusyErrorCellValueSubType | "Unknown" | "ExternalLinksGeneric" | "LoadingImage" | "PlaceholderInFormula";

Property Value

Excel.BusyErrorCellValueSubType | "Unknown" | "ExternalLinksGeneric" | "LoadingImage" | "PlaceholderInFormula"

Remarks

API set: ExcelApi 1.16

errorType

Represents the type of ErrorCellValue.

errorType?: ErrorCellValueType.busy | "Busy";

Property Value

busy | "Busy"

Remarks

API set: ExcelApi 1.16

previousValue

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

Optionally, a #BUSY! error may store the previous value stored in the cell, before the current transient operation began.

previousValue?: CellValue;

Property Value

Remarks

API set: ExcelApi BETA (PREVIEW ONLY)

type

Represents the type of this cell value.

type: CellValueType.error | "Error";

Property Value

error | "Error"

Remarks

API set: ExcelApi 1.16