Issue 125231 - duplicate range names when selected from Name Dialog neither shows correct names nor highlights correct cell ranges
Summary: duplicate range names when selected from Name Dialog neither shows correct na...
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: 4.1.0
Hardware: PC Linux 64-bit
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2014-07-09 22:13 UTC by samalipraveena
Modified: 2014-07-09 22:18 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

sample file for duplicate range names (12.57 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-07-09 22:13 UTC, samalipraveena
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description samalipraveena 2014-07-09 22:13:08 UTC
Created attachment 83667 [details]
sample file for duplicate range names

Overview: This bug is related to the test case AOOTest155 - update duplicate range names and ranges. The Duplicate range names in the Name Dialog box are all same without the imported sheet name and thereby unclear; when you select one of these names, it always highlights the workbook cell ranges.

Steps to Reproduce:
1. Open AOO calc 4.1.1
2. Import/open the excel attached with the test case, the same which i've attached with this bug.
3. Click on the Name box. It will show you three "data" range names and three "test" range names. Here, the range names doesn't include the imported sheet name.
4. Try selecting one of these and you'll see it always highlights only the workbook range name. Instead, open Insert->Names->Define and select the duplicate range names from this dialog, you'll see it shows the imported sheet name as well as highlights the correct cell ranges.

Build in which the error found:
AOO 4.1.1 Branch Build Revision (1603804)