https://issues.apache.org/ooo/show_bug.cgi?id=124256
--- Comment #7 from [email protected] --- 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. -- 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.
