Created attachment 113030 [details]
For demonstration of bug by following steps given in description.
Moving a sheet changes the evaluation of references to labels. It should not. This is demonstrated by performing the following steps on attached file LabelRelSheetAddress.ods.
1. "Edit > Sheet > Move/Copy (Copy is preselected) > Insert before Sheet1 > OK"
2. On the new sheet "Sheet1_2", the cell B2 is evaluated to "#NAME?". The reference to 'label1' seems to be the problem even though "Insert > Names > Labels" shows that 'label1' is defined as column label $Sheet1.$A$1.
3. "Edit > Sheet > Move/Copy (Move) > -move to end position- > OK". Now on "Sheet1_2", cell B2 is evaluated to 303. Moving the sheet shouldn't change the evaluation of references to labels.
Please see related Bug 88963, Bug 88979,
I can confirm these findings in Fedora 21
Build ID: d1c9bd13ec7af93f5368dfda6d6d3c955f0b0816
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-01-28_01:15:30
(In reply to Tim Lloyd from comment #1)
> I can confirm these findings in Fedora 21
Confirmed -> Setting to NEW. OS = All
If you enable:
Tools - Options - LibreOffice Calc - Calculate - General Calculations - Automatically find column and row labels
you should find that this works as you would expect.