Edit

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.
lambdaInCell = "LambdaInCell"

An error caused by a cell's formula evaluating to a lambda value. 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.
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.