Created attachment 114088 [details] screenshot of calc, everything cool When I delete a subset of cells, named ranges in different row/col shift. Between the attached screenshots, I delete cells C18:C40 and choose 'shift left'. Observe how named cell E3 now references D3 - that shift occurred for the whole D3:E6 range. I don't quite understand bug 87153 but suspect it may be related/dup.
Created attachment 114089 [details] screenshot of calc, after deleting C18:C40 (shifted name apparent)
I can reproduce with Version: 4.4.3.0.0+ Build ID: 8106e522c4ea2ae4441ec571579a38eeb6d9af04 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-4, Time: 2015-03-13_12:39:32 Reproducible with LibreOffice 3.5.0 Build ID: d6cde02 Not sure if it's a bug, for example excel do the same.
(In reply to raal from comment #2) > > Not sure if it's a bug, for example excel do the same. Yikes. I wouldn't even have caught this behavior without judicious Ctrl+z action. I'm afraid if that's how Excel does it, somebody will argue to keep this behavior. Let's be better than Excel.
Sorry that response wasn't totally clear. I consider this a bug because it means named ranges don't provide the same stability as plain cell references. The big advantage of names is to avoid plain refs but, as is, ranges can be affected unknowingly. The error condition it produces can be quite obvious but just *what* changed isn't, ergo that kind of change shouldn't happen.
(In reply to bugzilla-libreoffice from comment #3) > > Not sure if it's a bug, for example excel do the same. > > Yikes. I wouldn't even have caught this behavior without judicious Ctrl+z > action. I'm afraid if that's how Excel does it, somebody will argue to keep > this behavior. Let's be better than Excel. Two important things to note: 1) We want users to have an intuitive experience, so unless it's really egregious (e.g. year 1900 date bug), we need to seriously consider compatibility. 2) Changing existing behavior can be seen as a regression ("One man's bug is another man's feature"). What seems like a minor pecadillo can blossom into a HUGE issue if we're not careful. CC'ing both Moggi and jphilipz for advice here.
I'm sorry but this is the expected behavior.