Create a new sheet level name, say $Sheet1.$A$1:$B$5 refers to some name but only on Sheet1.
Fill some values in it.
Create some reference, say =INDEX(MyName;1;1)
Select the named range and move it (cut|drag).
Symptom #1: The reference does not update unless you do a hard recalculation [Ctrl+Shift+F9]
The reference is still valid. The formula points to the same value.
Call the names dialog again.
Symptom #2: According to the dialog the named reference still points to the $Sheet1.$A$1:$B$5 which is obviously not true.
Symptom #3: After save, close, reload the name refers to the first position.
Problem: It is impossible to move a named reference on sheet level without manual adjustment in the dialog.
*** Bug 38227 has been marked as a duplicate of this bug. ***
See also i#115506: Reports Go-OO failure to update named range
Go-oo: OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 2010-07-18
and reports issue fixed in OOo3.3rc.
LeMoyne Castle, this is a totally different issue.
We have here the problem that we don't update the reference for sheet local range names. OO doesn't have those and the update reference for global range names are already implemented.
I'll have alook at it, I'm aware of the problem in the source code.
Ok sent an initial patch for review into 3-4.
There are still some issues not mentioned in this bug report:
I will have to deal with them when I fixed a problem that prevents the work on it.
While we're in it:
The bastards do not show up in the navigator nor name box.
(In reply to comment #5)
> While we're in it:
> The bastards do not show up in the navigator nor name box.
What do you mean with this? Do you mean the Names->Insert Dialog? this is fixed in master for 3.5 but will not get into the 3-4 branch.
Otherwise please give a detail description how to reproduce it.
The navigator is the docking window which shows all the names, database ranges, objects, scenarios and other sheets when you hit F5.
The name box is the combo box left of the formula bar. It accepts valid range addresses, data range names and unambiguous named expressions, i.e. named expressions referring to a completely absolute range address (single range $Sheet.$A$1 or $Sheet.$A$1:$X$99 with 3 or 5 dollar signs respectively).
When you type something into that box which is neither an existing data range name, named expression nor a valid address string, a new, completely absolute range name will be created. If the entered expression points to some range unambiguously, the range gets selected.
please add all future enhancements around local range names at:
I'll use this bug only for all update problems
And while we are in the matter of this completely flawed implementation:
Create a name on sheet level, say XName refers to Sheet1.A1
Create a reference, say B1 =XName and enter something in XName
Select another cell, say A2 and enter something.
Now type XName into the name box which will create another XName on document level making all references point to this one.
please don't add any further bugs here but in https://bugs.freedesktop.org/show_bug.cgi?id=38565
I'll close this bug as soon as I fixed all update problems. The other bug is for all outstanding work on local range names. Thanks.
pushed to master and asked for sign-off for 3-4
all other enhancements or comments if not related to these update problems please in fdo#38565