Excel.CalcErrorCellValueSubType enum
Represents types of #CALC! errors.
Remarks
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 |
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. |
Office Add-ins