Skip to content
Sheetwrite

Sheetwrite / Documentation

shiftA1Refs@sheetwrite/core

Shift relative A1 references in a formula by (dRow, dCol) — used when a formula is filled into other cells.

Shift relative A1 references in a formula by (dRow, dCol) — used when a formula is filled into other cells. Absolute parts ($A, A$1) stay fixed, and tokens preceded by an alphanumeric (function names, identifiers) are skipped.

Declaration

function shiftA1Refs(src: string, dRow: number, dCol: number): string