Skip to content

VertexId

Base class for vertex identifiers, which unambiguously identify the vertices for cells, ranges and defined names in a model’s dependency graph.

new VertexId(workbookKey, key): VertexId;

number

The dependency graph key of the workbook

string

The key of this vertex ID (which includes the workbook key)

VertexId

key: string;

Underlying string encoding of the identifier. Guaranteed to be identical for two vertex ID instances that identify the same thing within a model, and to be distinct for instances that don’t.


workbookKey: number;

Key identifying a workbook in this model. Although it is numeric, the number does not necessarily indicate its ordering in the model.

contains(otherId): boolean;

Check whether this vertex ID fully contains another (meaning all of the other vertex ID is within this one)

KnownVertexId

boolean


overlaps(otherId): boolean;

Check whether this vertex ID overlaps another.

KnownVertexId

boolean


toRange(): Range | null;

Derive a bare Range for the cell or range represented by this vertex ID, without workbook or sheet attachment. For a vertex ID that does not represent a cell or range, this is null.

Range | null


toString(): string;

string


static fromKey(key): KnownVertexId;

Make a VertexId instance for the given key. Two calls with the same key will return distinct but equivalent instances.

string

KnownVertexId