Excel.SpillErrorCellValueSubType enum

Represents types of #SPILL! errors.

Remarks

[ API set: ExcelApi 1.16 ]

Fields

collision = "Collision"

An error caused by a dynamic array attempting to spill data into a cell that isn't empty. Displays as error type #SPILL! in Excel.

indeterminateSize = "IndeterminateSize"

An error caused by a dynamic array formula that can't be evaluated in a single calculation. Displays as error type #SPILL! in Excel.

mergedCell = "MergedCell"

An error caused by a merged cell blocking a dynamic array. Displays as error type #SPILL! in Excel.

outOfMemoryWhileCalc = "OutOfMemoryWhileCalc"

An error caused by insufficient memory when attempting to calculate a dynamic array formula. Displays as error type #SPILL! in Excel.

table = "Table"

An error caused by entering a dynamic array formula in a table. Displays as error type #SPILL! in Excel.

unknown = "Unknown"

An unknown type of error. Displays as error type #SPILL! in Excel.

worksheetEdge = "WorksheetEdge"

An error caused by a dynamic array attempting to spill over the edge of the worksheet. Displays as error type #SPILL! in Excel.