Issue 84667

Summary: Range Naming non-consecutive cells
Product: Calc Reporter: webweaver64 <sharilynn>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues, openoffice
Version: OOo 3.1   
Target Milestone: ---   
Hardware: All   
OS: Windows, all   
Issue Type: DEFECT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Description webweaver64 2007-12-17 19:51:18 UTC
I am unable to name a range that includes non-consecutive cells. I also lose any
ranges that are named when importing from excel.
Comment 1 webweaver64 2008-01-06 06:07:43 UTC
It looks like the following issues also are about this issue, however they are
from version 1.x and again this effect spreadsheets being imported from excel.
Until this is fixed I'm unable to stop using excel.

Comment 2 drking 2008-01-29 08:38:33 UTC
"I am unable to name a range that includes non-consecutive cells."

From issue 25769:
> Calc doesn't allow a multi-selection to be defined as a name

"I also lose any ranges that are named when importing from excel."

I am able to import ranges from Excel97 to OOo2.3.1 (WinXP). They do not show 
in the Data-Select Range... dialogue - but they do work in formulae. This even 
applies to non-contiguous ranges, so having imported an Excel generated file 
with a non-contiguous range called 'myxlrange' I can do =AREAS(myxlrange) to 
count the number of non-contiguous ranges.

Unfortunately, I can then enter the same name 'myxlrange' in the Data-Define 
range dialogue, which enables me to select that new range via Data-Select 
Range... - however any formulae still use the Excel defined range.

webweaver64, are you able to confirm that you get this behaviour too? I'm 
anxious to be sure that this is not just my system.
Comment 3 webweaver64 2008-01-29 17:14:11 UTC
Yes I can confirm this. I can create a range in excel (2003). Open it in OOo
(2.3.1 & Dev 2.4.0m4). The range is not listed in Data>Select Range, nor can you
type the name in the location box. Any formula that used the name, doesn't
change. I can create a range in OOo with the same name, and use Data>Select to
select this range. If I create a new formula with the range name it uses the one
originally created in excel, not the range created in OOo. When reopened in
excel, it adds a _1 to the new range; e.g.: range_1. I'm changing this to
Windows all as I was using both Vista and XP to check this. I would bet this is
not OS specific.
Comment 4 oc 2008-07-15 10:44:28 UTC
reassigning features and enhancements to user which
will be the default owner for those tasks (was introduced some time ago)
Comment 5 webweaver64 2009-06-06 22:05:06 UTC
This is still true for 3.1
Comment 6 Edwin Sharp 2014-01-10 13:08:18 UTC
This is a defect if non contiguous range defined in Excel 2010 can be detected but a new range can not be defined in Calc.

AOO410m1(Build:9750)  -  Rev. 1552994
Win 7