Created attachment 96076 [details] Sample file for verify Win7x64Ultimate Moving the cells: B2 or B4:C4 doesn't update the references of their named ranges. No difference between drag&drop or Ctrl+X plus Ctrl+V Inserting/Deleting Columns/Rows seems to work properly. Last version working: Version: 4.1.6.0.0+ Build ID: 0b772a163b2536fc55aa3b4de925119e33af769 Versions with the issue: Version: 4.2.0.4 Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71 Version: 4.2.2.1 Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f Version: 4.2.3.1 Build ID: 3d4fc3d9dbf8f4c0aeb61498a81f91c5b7922f13 Version: 4.2.4.0.0+ Build ID: e1823627f35e4419880769fdd05acddbd0a9c25c TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-03-18_14:25:19 Version: 4.3.0.0.alpha0+ Build ID: 12ae7672f285da1d4c730315e8db23b3396b71cc TinderBox: Win-x86@39, Branch:master, Time: 2014-03-14_00:18:00
As per Kohei's comment https://bugs.freedesktop.org/show_bug.cgi?id=76402#c4, that's no possible for relative references inside named ranges. So not a bug.