Skip to content

PivotCellWriteBlocked

Thrown when a direct cell-value write targets a coordinate inside a pivot table’s output region. Output cells are materialized from the pivot’s layout on refresh; change the source data or the pivot’s configuration instead.

  • Error
new PivotCellWriteBlocked(pivotTableName, cellRef): PivotCellWriteBlocked;

string

Reference

PivotCellWriteBlocked

Error.constructor
optional cause?: unknown;
Error.cause

cellRef: Reference;

message: string;
Error.message

name: string = 'PivotCellWriteBlocked';
Error.name

pivotTableName: string;

optional stack?: string;
Error.stack

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.

Error.stackTraceLimit
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();

object

Function

void

Error.captureStackTrace

static isError(error): error is Error;

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

unknown

error is Error

Error.isError

static prepareStackTrace(err, stackTraces): any;

Error

CallSite[]

any

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

Error.prepareStackTrace