Apache OpenOffice (AOO) Bugzilla – Issue 125231
duplicate range names when selected from Name Dialog neither shows correct names nor highlights correct cell ranges
Last modified: 2014-07-09 22:18:04 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)