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).Desired behavior:
References bound to defined names (aka named variables) should track
the same way they do in other contexts.Platform:
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