Edit

Share via

Excel.FieldErrorCellValue interface

  • Reference
Package:
excel

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

Remarks

[ API set: ExcelApi 1.16 ]

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 FieldErrorCellValue.
errorType

Represents the type of ErrorCellValue.
fieldName

Represents the field which was not found by FIELDVALUE.
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?: "#FIELD!" | string;

Property Value

"#FIELD!" | string

Remarks

[ API set: ExcelApi 1.16 ]

errorSubType

Represents the type of FieldErrorCellValue.

errorSubType?: FieldErrorCellValueSubType | "Unknown" | "WebImageMissingFilePart" | "DataProviderError" | "RichValueRelMissingFilePart";

Property Value

Excel.FieldErrorCellValueSubType | "Unknown" | "WebImageMissingFilePart" | "DataProviderError" | "RichValueRelMissingFilePart"

Remarks

[ API set: ExcelApi 1.16 ]

errorType

Represents the type of ErrorCellValue.

errorType?: ErrorCellValueType.field | "Field";

Property Value

field | "Field"

Remarks

[ API set: ExcelApi 1.16 ]

fieldName

Represents the field which was not found by FIELDVALUE.

fieldName?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.16 ]

type

Represents the type of this cell value.

type: CellValueType.error | "Error";

Property Value

error | "Error"

Remarks

[ API set: ExcelApi 1.16 ]