Excel.SpillErrorCellValue interface

Represents the value of a cell containing a #SPILL! 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.

columnCount

Represents the number of columns that would spill if there were no #SPILL! error.

errorSubType

Represents the type of SpillErrorCellValue.

errorType

Represents the type of ErrorCellValue.

rowCount

Represents the number of rows that would spill if there were no #SPILL! error.

type

Represents the type of this cell value.

Property Details

basicType

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

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?: "#SPILL!" | string;

Property Value

"#SPILL!" | string

Remarks

[ API set: ExcelApi 1.16 ]

columnCount

Represents the number of columns that would spill if there were no #SPILL! error.

columnCount?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.16 ]

errorSubType

Represents the type of SpillErrorCellValue.

errorSubType?: SpillErrorCellValueSubType | "Unknown" | "Collision" | "IndeterminateSize" | "WorksheetEdge" | "OutOfMemoryWhileCalc" | "Table" | "MergedCell";

Property Value

Excel.SpillErrorCellValueSubType | "Unknown" | "Collision" | "IndeterminateSize" | "WorksheetEdge" | "OutOfMemoryWhileCalc" | "Table" | "MergedCell"

Remarks

[ API set: ExcelApi 1.16 ]

errorType

Represents the type of ErrorCellValue.

errorType?: ErrorCellValueType.spill | "Spill";

Property Value

spill | "Spill"

Remarks

[ API set: ExcelApi 1.16 ]

rowCount

Represents the number of rows that would spill if there were no #SPILL! error.

rowCount?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.16 ]

type

Represents the type of this cell value.

type: CellValueType.error | "Error";

Property Value

error | "Error"

Remarks

[ API set: ExcelApi 1.16 ]