(comment fdo#38380#7)
> 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.

(comment fdo#38380#9)
> 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.

import/export to xls/xlsx don't respect local range names

haven't looked closer into it

https://bugs.freedesktop.org/show_bug.cgi?id=37763

issue in comment2 should be fixed in master

export to xlsx works now in master

xls export/import should be done by Kohei already

https://bugs.freedesktop.org/show_bug.cgi?id=37550

Input line does not help with auto-completion for local range names.

Adding myself to CC list in order to help to test it.

all information are now collected at: http://wiki.documentfoundation.org/Design/Whiteboard/Calc_Range_Names

xlsx import is still missing

api is missing

https://bugs.freedesktop.org/show_bug.cgi?id=41385

api is implemented now: syntax for e.g. Basic: ThisComponent.sheets(0).rangeNames

changes to name box and navigator are implemented

xlsx import is implemented in master

everything important from this bug is now implemented and should be in 3.5