Description:
@erAck solved a problem with the 'name box' not showing a name when selecting a range with a name with scope 'local' in tdf#67007, there are some shortcomings, left ones and new, 

consider a sheet 'sheet1' with two named ranges, both named test, one with scope 'global', one with scope 'sheet1' (regardlees if it's a good idea from a user to use such, it's possible and will occur), 

- selecting either of theese ranges will display 'test' in the name box (since ver. 7.1), without hint which of them it is, users may be irritated checking the 'global' range being 'test', and the formula '=sum(test)' producing 'wrong' results, as it calculates the sum of 'test(sheet1)', 

- clicking the name box will offer two ranges, 'test' and 'test(sheet1)', clicking either of theese names will select the local range which is wrong for te global range, users may get the impression that the local range has the name of the local range, 

- the 'global range' test is not 'addressable' while in an sheet which has a local named range with identical name, 

- copying parts of a sheet which completely covers a named range doesn't carry that name to the new destination, neither for local nor global names, 

- moving parts of a sheet which completely covers a named range doesn't carry that name to the new destination, neither for local nor global names, 

- the range adressed by the former name is changed to the new destination, but selecting the covered range on the new sheet doesn't show a name in the name box, 

- references in formulas pointing to that range are changed 'old-sheet-name.test', and do work, 

- undo of such actions sometimes doesn't bring the name back, 

- copying such sheet with 'move or copy sheet' runs into a conflict that it normally stays with the name for the global range and converts it to scope local , that would result in two identical names with identical scope on one sheet, 

- instead names like test(sheet1_2) are created when copying to 'sheet2', and selecting that name from the name box results in an error 'you must select a valid name ...', 

- after above copy the 'global range' on the new sheet has no name, 

solution? i don't know, 

- show name with 'scope' in named box when a named range is selected, 

- make global ranges select- / addressable by the label 'name(global)', 

- forbid the use of identical names for local and global ranges? at least for being on the same sheet, 

i'm unsure if this description covers all curiosities, 

to stay calm, ex$el (tested '2010') is confused with such nonsense too, it offers names as 'book1.test' for the global range and changes it in formulas to 'sheet1.test', then calculating the local range ... 

Steps to Reproduce:
see description above, try to handele two ranges test(sheet1) and test(global) on the same sheet, and copying that sheet, 

Actual Results:
shortcomings as in description

Expected Results:
consistent handling, avoiding constructions which can't be handeled, or meaningful warnings and error message, 


Reproducible: Always


User Profile Reset: Yes



Additional Info:
tested ver. 3.5.1.2, 6.1.6.3, 7.1.0.0.a0+