https://issues.apache.org/ooo/show_bug.cgi?id=124256
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from [email protected] --- 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 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 -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
