reference bound to defined name (aka named variable) does not track when cell moves
Background: Normal and expected observations:
Please refer to the attached example spreadsheet. Defined name "foo" is defined as $c$4. The value in c4 is 1234. The formula in d5 is =$c$4. The formula in e5 is =foo. The cells c4, d5, and e5 all evaluate to the same value. Now delete column A or delete row 1. (Menu -> Edit -> Delete -> ....) All cells in the spreadsheet shift to new locations, as expected. In particular, the formula in the red cell changes, so that the meaning is unchanged. So far so good.
Unexpected and undesirable observations:
The problem is, defined name foo is still defined as $c$4; the formula stays the same but the meaning is changed. This completely defeats the purpose of having defined names (aka named variables).
References bound to defined names (aka named variables) should track the same way they do in other contexts.
This bug has existed for eons. It still exists with all the same symptoms in a fairly recent development (git) version. :; gnumeric --version gnumeric version '1.12.38' datadir := '/usr/local/share/gnumeric/1.12.38' libdir := '/usr/local/lib/gnumeric/1.12.38' :; /usr/src/gnome/gnumeric/src/gnumeric --version gnumeric version '1.12.47' datadir := '/usr/src/gnome/install/share/gnumeric/1.12.47' libdir := '/usr/src/gnome/gnumeric' :; uname -srmo Linux 4.19.42+ x86_64 GNU/Linux :; lsb_release -a LSB Version: core-9.20170808ubuntu1-noarch:cxx-3.0-amd64:cxx-3.0-noarch:cxx-3.1-amd64:cxx-3.1-noarch:cxx-3.2-amd64:cxx-3.2-noarch:cxx-4.0-amd64:cxx-4.0-noarch:cxx-4.1-amd64:cxx-4.1-noarch:desktop-3.1-amd64:desktop-3.1-noarch:desktop-3.2-amd64:desktop-3.2-noarch:desktop-4.0-amd64:desktop-4.0-noarch:desktop-4.1-amd64:desktop-4.1-noarch:graphics-2.0-amd64:graphics-2.0-noarch:graphics-3.0-amd64:graphics-3.0-noarch:graphics-3.1-amd64:graphics-3.1-noarch:graphics-3.2-amd64:graphics-3.2-noarch:graphics-4.0-amd64:graphics-4.0-noarch:graphics-4.1-amd64:graphics-4.1-noarch:multimedia-3.2-amd64:multimedia-3.2-noarch:multimedia-4.0-amd64:multimedia-4.0-noarch:multimedia-4.1-amd64:multimedia-4.1-noarch:printing-9.20170808ubuntu1-noarch:qt4-3.1-amd64:qt4-3.1-noarch:security-9.20170808ubuntu1-noarch Distributor ID: Ubuntu Description: Ubuntu 18.04.4 LTS Release: 18.04 Codename: bionic