SheetEdgeBlockedError
Thrown when an insert (insertRows / insertColumns / insertCells) would push non-empty cells
or a drawing off the edge of the sheet, which Excel also refuses (“To prevent possible loss of
data…” / “Cannot shift objects off sheet”), leaving the sheet untouched. Unlike the other
guards this protects the sheet’s own bounds rather than a named table/pivot/data-table, so it
carries no structure name --- only reason (content vs drawing) and the operation that was
refused.
Extends
Section titled “Extends”Constructors
Section titled “Constructors”Constructor
Section titled “Constructor”new SheetEdgeBlockedError( reason, sheetName, operation): SheetEdgeBlockedError;Parameters
Section titled “Parameters”reason
Section titled “reason”sheetName
Section titled “sheetName”string
operation
Section titled “operation”string
Returns
Section titled “Returns”SheetEdgeBlockedError
Overrides
Section titled “Overrides”Properties
Section titled “Properties”message
Section titled “message”message: string;Inherited from
Section titled “Inherited from”name: string;Overrides
Section titled “Overrides”operation
Section titled “operation”operation: string;The insert operation that was refused (insertRows / insertColumns / insertCells).
reason
Section titled “reason”reason: SheetEdgeBlockedReason;Whether cell content or a drawing would have overflowed.
sheetName
Section titled “sheetName”sheetName: string;Name of the sheet holding the protected region that blocked the operation.
Inherited from
Section titled “Inherited from”stack?
Section titled “stack?”optional stack?: string;Inherited from
Section titled “Inherited from”stackTraceLimit
Section titled “stackTraceLimit”static stackTraceLimit: number;The Error.stackTraceLimit property specifies the number of stack frames
collected by a stack trace (whether generated by new Error().stack or
Error.captureStackTrace(obj)).
The default value is 10 but may be set to any valid JavaScript number. Changes
will affect any stack trace captured after the value has been changed.
If set to a non-number value, or set to a negative number, stack traces will not capture any frames.
Inherited from
Section titled “Inherited from”EditBlockedError.stackTraceLimit
Methods
Section titled “Methods”captureStackTrace()
Section titled “captureStackTrace()”static captureStackTrace(targetObject, constructorOpt?): void;Creates a .stack property on targetObject, which when accessed returns
a string representing the location in the code at which
Error.captureStackTrace() was called.
const myObject = {};Error.captureStackTrace(myObject);myObject.stack; // Similar to `new Error().stack`The first line of the trace will be prefixed with
${myObject.name}: ${myObject.message}.
The optional constructorOpt argument accepts a function. If given, all frames
above constructorOpt, including constructorOpt, will be omitted from the
generated stack trace.
The constructorOpt argument is useful for hiding implementation
details of error generation from the user. For instance:
function a() { b();}
function b() { c();}
function c() { // Create an error without stack trace to avoid calculating the stack trace twice. const { stackTraceLimit } = Error; Error.stackTraceLimit = 0; const error = new Error(); Error.stackTraceLimit = stackTraceLimit;
// Capture the stack trace above function b Error.captureStackTrace(error, b); // Neither function c, nor b is included in the stack trace throw error;}
a();Parameters
Section titled “Parameters”targetObject
Section titled “targetObject”object
constructorOpt?
Section titled “constructorOpt?”Function
Returns
Section titled “Returns”void
Inherited from
Section titled “Inherited from”EditBlockedError.captureStackTrace
prepareStackTrace()
Section titled “prepareStackTrace()”static prepareStackTrace(err, stackTraces): any;Parameters
Section titled “Parameters”Error
stackTraces
Section titled “stackTraces”CallSite[]
Returns
Section titled “Returns”any
https://v8.dev/docs/stack-trace-api#customizing-stack-traces