Author Topic: Cut/paste of cell value does not update references to that cell  (Read 381 times)

wd_perf

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 26
    • View Profile
Cut/paste of cell value does not update references to that cell
« on: September 13, 2022, 04:13:55 am »
Steps to replicate:
1) Go to https://paramquery.com/pro/demos
2) Click "Cut copy paste" demo
3) In cell A1 enter "=B1" so that A1 references B1's value
4) Select cell B1 and click "Cut"
5) Select cell B2 and click "Paste"

The formula in cell A1 is not updated to point to the new location of B2. In Excel and Google Sheets cutting and pasting updates any references to cut/pasted cells.