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 Version: 4.5.0.0.alpha0+ Build ID: d1c9bd13ec7af93f5368dfda6d6d3c955f0b0816 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-01-28_01:15:30 Locale: en_AU
(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.