apps-script-utils 2.1.1 Help

updateSheetNameInA1Notation

function updateSheetNameInA1Notation(a1Notation: string, sheetName?: string | null): string;

What a formula rewrite needs after a sheet is renamed or copied. A name that needs quoting is quoted; a notation that had no sheet name gets one.

Parameters

Parameter

Type

Description

a1Notation

string

The notation to rewrite.

sheetName (optional)

string \| null

The sheet name to put in.

Returns

string — the rewritten notation.

Examples

Renaming

updateSheetNameInA1Notation("Sheet1!A1", "Data"); // => "Data!A1"

See also

Source

src/appsscript/sheet/updateSheetNameInA1Notation.ts

23 September 2026

This documentation was generated with AI (Claude) from the library's source code.