Table formulas - Relative references and the '$' operator)

TLDR; No way to copy formulas with relative references.

A key feature, of different spreadsheet applications, is the possibility to copy/paste formula by reference and eventually control it via the $ operator.

By default, without the $, the row and column references are "moved" according to the position of the target cell. While with the operator, they are fixed to the actual row/col value defined in the original formula.

This behavior seems missing in table formulas and actually, it seems it's only possible to copy paste is the exact same text the resulting.

Real scenario
A simple price * quantity table with multiple items

Anytwo -Copy/paste the formula keeps the original refs, so it doesn't help much, it must be done manually for every row




Common spreadsheet apps - copy/pasting the cell (not the actual text) moves the refs according to the target cell cell. So copy/pasting the formula in each row is enough, no manual edit.