Edit

Share via

Excel.CalcErrorCellValueSubType enum

  • Reference
Package:
excel

Represents types of #CALC! errors.

Remarks

[ API set: ExcelApi 1.16 ]

Fields

arrayOfArrays = "ArrayOfArrays"

An error caused by including an array in an array. Displays as error type #CALC! in Excel.
arrayOfRanges = "ArrayOfRanges"

An error caused by including a range in an array. Displays as error type #CALC! in Excel.
dataTableReferencedPendingFormula = "DataTableReferencedPendingFormula"

An error caused by a data table referencing a pending formula. The pending formula is likely asynchronous. Displays as error type #CALC! in Excel.
emptyArray = "EmptyArray"

An error caused by an empty array. Displays as error type #CALC! in Excel.
eRegexReplaceCharLimit = "ERegexReplaceCharLimit"

An error caused by text that's longer than 65,535 characters. Displays as error type #CALC! in Excel.
externalQueryRef = "ExternalQueryRef"

An error caused by a reference to a Power Query query in a different workbook. Displays as error type #CALC! in Excel.
invalidPythonObject = "InvalidPythonObject"

An error caused by a formula referencing a value returned by an external code service in a different workbook. Displays as error type #CALC! in Excel.
lambdaInCell = "LambdaInCell"

An error caused by a cell's formula evaluating to a lambda value. Displays as error type #CALC! in Excel.
pythonGridQuery = "PythonGridQuery"

An error caused by a Power Query query referencing data in a sheet. Displays as error type #CALC! in Excel.
pythonPowerQueryDataUploadEtagChanged = "PythonPowerQueryDataUploadEtagChanged"

An error caused by a Power Query query ID change. Displays as error type #CALC! in Excel.
pythonPowerQueryDataUploadSizeLimitExceeded = "PythonPowerQueryDataUploadSizeLimitExceeded"

An error caused by Power Query exceeding the limit for data uploaded to an external code service. Displays as error type #CALC! in Excel.
queryInCell = "QueryInCell"

An error caused by a formula returning a reference to a Power Query query. Displays as error type #CALC! in Excel.
requestTooLarge = "RequestTooLarge"

An error caused by a formula generating too large a request for an external code service. Displays as error type #CALC! in Excel.
textOverflow = "TextOverflow"

An error caused by a cell's formula returning a string that exceeds the maximum of 32767 characters. Displays as error type #CALC! in Excel. Some characters, like emoji, may appear to be one character in the Excel UI but are actually processed as surrogate characters. A surrogate character counts as multiple characters toward the maximum character limit.
tooDeeplyNested = "TooDeeplyNested"

An error caused by a CellValue object that is too deeply nested within another CellValue. Displays as error type #CALC! in Excel.
tooManyCells = "TooManyCells"

An error caused by a function referencing too many cells. Displays as error type #CALC! in Excel.
unexpectedReturnValue = "UnexpectedReturnValue"

An error caused by an external code service returning an unexpected result. Displays as error type #CALC! in Excel.
uninitializedPythonObject = "UninitializedPythonObject"

An error caused by an uninitialized Python Object. Displays as error type #CALC! in Excel.
unknown = "Unknown"

An unknown type of error. Displays as error type #CALC! in Excel.
unsupportedLifting = "UnsupportedLifting"

An error caused by attempting to lift an unsupported formula (such as a Dynamic UDF) over an array. Displays as error type #CALC! in Excel.