Add missing enhancements for local range names here
> 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.
> 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
issue in comment2 should be fixed in master
export to xlsx works now in master
xls export/import should be done by Kohei already
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
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