Build installed:  17 Feb development snapshot

Data - Select Range... -> empty although Sheet1 F2:J10 is data.
AOO410m1(Build:9750)  -  Rev. 1565724
Rev.1565724
Win 7

I think there is a misunderstanding. Named cells/ranges are not database ranges.
You can select them with the name box next to the formula bar.
Or Insert -> Names.. -> Define..

but there is indeed an issue:

attachment 82614 [details] seems to have 6 named ranges, dissected:
<definedName name="data" localSheetId="0">Sheet1!$F$2:$J$10</definedName>
<definedName name="data" localSheetId="1">Sheet1!$L$2:$P$10</definedName>
<definedName name="data">Sheet1!$A$2:$D$10</definedName>
<definedName name="test" localSheetId="0">Sheet1!$F$1</definedName>
<definedName name="test" localSheetId="1">Sheet1!$L$1</definedName>
<definedName name="test">Sheet1!$A$1</definedName>

*AOO 3.4.1* imports
data $Sheet1.$F$2:$J$10
data_1 $Sheet1.$L$2:$P$10
data_2 $Sheet1.$A$2:$D$10
test $Sheet1.$F$1
test_1 $Sheet1.$L$1
test_2 $Sheet1.$A$1
which are all available through the name box

*AOO 4.1* (rev. 1568575) imports
data $Sheet1.$A$2:$D$10
data    (Sheet1) $Sheet1.$F$2:$J$10
data    (Sheet2) $Sheet1.$L$2:$P$10
test $Sheet1.$A$1
test  (Sheet1) $Sheet1.$F$1
test_1 (Sheet2) $Sheet1.$L$1
data and test are available through the name box
but data and test are listed 3 times the (Sheetx)-part doesn't show
and it always selects the first range

the original report is not an issue but
the faulty is import is a regression

Ahh, yes, I see this now....thanks for the clarification regarding named ranges.  Shall I keep this bug report open for the regression issue you mention?  It would probably make sense to change the one liner description of we do.

Thank you j.nitschke

IMHO this bug should be used as an enhancement for better wording to reduce chance for confusion with databases.
The findings of comment 3 should be a new bug.

.

I digged a bit into the localSheetId feature and checked how it should work:

<definedName name="test" localSheetId="0">Sheet1!$F$1</definedName>
<definedName name="test" localSheetId="1">Sheet1!$L$1</definedName>
<definedName name="test">Sheet1!$A$1</definedName>

If you use the named range "test" in Sheet1 it should use the values in $Sheet1.$F$1 (sheet1 has localSheetId ="0")

Using "test" in Sheet2 it uses the value $Sheet1.$L$1 (sheet2 has localSheetId ="1")

in all other sheets the value from $Sheet1.$A$1 is used

This works *perfect* thanks to Bug 120478 - Name Scope enhancement for spreadsheet

there are only 2 problems
* the names are listed more than once (minor problem)
* if you pick a name it always marks the cell without localSheetId
  it should check on which sheet you are and show the named range used for this sheet, else this feature is very confusing

i.e. if you select test from the name box in Sheet1 it should jump to Sheet1!$F$1
  on Sheet2 it jumps to $Sheet1.$L$1 and on Sheet3 it jumps to Sheet1!$A$1

If ODF specs don't have a similar feature i would call this an enhancement.

This said it's not a faulty import and not a regression.

No Idea what the problem here might be. Do we only have a wrong description of an existing bug in report? Or in Comment 2? Or are j.nitschke@ok.de's observations something completely different? Further research required.

I agree with Edwin's Comment 5:
(a) I close this one because it's not an issue, but user error
(b) Submitted new Bug Report for j.nitschke@ok.de's results in Comment 3:
    "Bug 124293 - Section Range names truncated from underscore to end 
    in MSO .XLSX"

@j.nitschke:
Can you please check whether I correctly cited all your results?