DataTableEditBlocked

Thrown when a structural edit (row/column insert, delete or move, moveCells, clearCells) or a cell write would change part of a what-if data table in a way Excel refuses (verified empirically; see excel-test/data-table-structural-edits/RESULTS.md). Excel refuses via a modal alert or a silent no-op depending on the operation; Apiary surfaces the rejection so the host application can decide how to react.

Extends

• Error

Constructors

Constructor

new DataTableEditBlocked(
   dataTableRef,
   operationDescription,
   operation): DataTableEditBlocked;

Parameters

dataTableRef

string

operationDescription

string

operation

DataTableBlockedOperation

Returns

DataTableEditBlocked

Overrides

Error.constructor

Properties

cause?

optional cause?: unknown;

Inherited from

Error.cause

---

dataTableRef

dataTableRef: string;

A1 range of the data table’s result cells.

---

message

message: string;

Inherited from

Error.message

---

name

name: string = 'DataTableEditBlocked';

Overrides

Error.name

---

operation

operation: DataTableBlockedOperation;

The kind of edit that was refused.

---

stack?

optional stack?: string;

Inherited from

Error.stack

---

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

Error.stackTraceLimit

Methods

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

targetObject

object

constructorOpt?

Function

Returns

void

Inherited from

Error.captureStackTrace

---

isError()

static isError(error): error is Error;

Indicates whether the argument provided is a built-in Error instance or not.

Parameters

error

unknown

Returns

error is Error

Inherited from

Error.isError

---

prepareStackTrace()

static prepareStackTrace(err, stackTraces): any;

Parameters

err

Error

stackTraces

CallSite[]

Returns

any

See

https://v8.dev/docs/stack-trace-api#customizing-stack-traces

Inherited from

Error.prepareStackTrace