Copy, cut, and paste
Copy adjusts references to the paste target; cut moves a cell verbatim.
What it does
Select a cell and press Ctrl+C to copy or Ctrl+X to cut, then select a target and press Ctrl+V to paste.
- Copy + paste adjusts the formula's relative references by the paste offset —
=A1+B1copied from C1 to C3 becomes=A3+B3, while$-anchored parts stay put (=$A$1+B1→=$A$1+B3). The source is left untouched and the clipboard stays loaded, so you can paste it again. - Cut + paste moves the cell: the formula is written to the destination verbatim (no reference adjustment) and the source cell is cleared. The clipboard is consumed after that one paste.
Verified behavior
Matches Google Sheets: In Google Sheets, copying a formula and pasting it adjusts the formula's relative references by the row/column offset (copying "=A1+B1" from C1 to C3 yields "=A3+B3"), while $-anchored parts stay fixed ("=$A$1+B1" → "=$A$1+B3"); copy leaves the source and the clipboard intact, so it can be pasted again. Cutting and pasting instead MOVES the cell: the formula is written to the destination verbatim (no reference adjustment) and the source is cleared, and the clipboard is consumed after that one paste. (Sheets additionally rewrites OTHER formulas that referenced the moved cell so they keep pointing at it — that cross-reference remap needs engine support and is not yet modeled here; tracked as a follow-up.)
Copy a relative formula and paste — references shift by the offset
Given
- A1 =
10 - B1 =
20 - C1 =
=A1+B1 - A3 =
5 - B3 =
7
When I click C1, then press Control+c, then click C3, then press Control+v
Then
- C3 shows
12 - C1 shows
30 - C3 has formula
=A3+B3 - C1 has formula
=A1+B1
Copy shifts references by both the row and the column offset
Given
- A1 =
10 - B1 =
20 - C1 =
=A1+B1 - B3 =
7 - C3 =
5
When I click C1, then press Control+c, then click D3, then press Control+v
Then
- D3 shows
12 - D3 has formula
=B3+C3
Cut and paste — the formula moves verbatim and the source is cleared
Given
- A1 =
10 - B1 =
20 - C1 =
=A1+B1
When I click C1, then press Control+x, then click C3, then press Control+v
Then
- C3 shows
30 - C1 shows
null - C3 has formula
=A1+B1