Excel.FieldErrorCellValue interface

  • Reference
Package:
excel

Warning

This API is now deprecated.

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

Warning

This API is now deprecated.

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

Warning

This API is now deprecated.

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

Warning

This API is now deprecated.

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

Warning

This API is now deprecated.

Represents the type of ErrorCellValue.

errorType?: ErrorCellValueType.field | "Field";

Property Value

field | "Field"

Remarks

[ API set: ExcelApi 1.16 ]

fieldName

Warning

This API is now deprecated.

Represents the field which was not found by FIELDVALUE.

fieldName?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.16 ]

type

Warning

This API is now deprecated.

Represents the type of this cell value.

type: CellValueType.error | "Error";

Property Value

error | "Error"

Remarks

[ API set: ExcelApi 1.16 ]