Summary
There's no way to copy a range's formulas/format down or across with relative-reference adjustment. gog sheets copy is sheet-level; gog sheets raw is read-only (Spreadsheets.Get); gog sheets batch-update only writes value ranges. Filling per-row formulas down a column currently requires inlining every fully-spelled-out formula via large value writes — high-token and error-prone.
Ask
Add a range copy/fill subcommand mapping to the Sheets API's spreadsheets.batchUpdate:
gog sheets copy-paste <spreadsheetId> <sourceRange> <destRange> [--type=NORMAL|FORMULA|FORMAT|VALUES|...] [--transpose]
# or
gog sheets fill <spreadsheetId> <sourceRange> <destRange> # autoFill / PASTE_FORMULA semantics
CopyPasteRequest{source, destination, pasteType, pasteOrientation} covers fill-down: copy AP2:AW71 → AP2:AW120 with PASTE_FORMULA tiles the formulas with relative-ref adjustment.AutoFillRequest{range, useAlternateSeries} covers series autofill.
This turns a multi-call, high-token formula transcription into a single call.
Filed from usage of the gogcli-mcp wrapper.
Summary
There's no way to copy a range's formulas/format down or across with relative-reference adjustment.
gog sheets copyis sheet-level;gog sheets rawis read-only (Spreadsheets.Get);gog sheets batch-updateonly writes value ranges. Filling per-row formulas down a column currently requires inlining every fully-spelled-out formula via large value writes — high-token and error-prone.Ask
Add a range copy/fill subcommand mapping to the Sheets API's
spreadsheets.batchUpdate:CopyPasteRequest{source, destination, pasteType, pasteOrientation}covers fill-down: copyAP2:AW71→AP2:AW120withPASTE_FORMULAtiles the formulas with relative-ref adjustment.AutoFillRequest{range, useAlternateSeries}covers series autofill.This turns a multi-call, high-token formula transcription into a single call.
Filed from usage of the gogcli-mcp wrapper.