TableEditBlockedError
Thrown when a bounded insertCells/deleteCells, or a sortCells, would tear a worksheet
table (an Excel Table) --- leaving part of it behind, or rearranging structure that is not
sortable data. A delete may only touch a table by removing whole table rows (shift up) or whole
table columns (shift left), and a table elsewhere in the shift path must have its full span
inside the shifted band so it moves whole. A sort may only permute whole rows of a table’s data
body, across the table’s full width.
Extends
Section titled “Extends”Constructors
Section titled “Constructors”Constructor
Section titled “Constructor”new TableEditBlockedError( tableName, sheetName, operation, operationDescription, detail?): TableEditBlockedError;Parameters
Section titled “Parameters”tableName
Section titled “tableName”string
sheetName
Section titled “sheetName”string
operation
Section titled “operation”operationDescription
Section titled “operationDescription”string
detail?
Section titled “detail?”string
Returns
Section titled “Returns”TableEditBlockedError
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: TableBlockedOperation;The kind of edit that was refused.
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”tableName
Section titled “tableName”tableName: string;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