Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Range Naming non-consecutive cells|
|Component:||editing||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||elish, issues, openoffice|
|Issue Type:||DEFECT||Latest Confirmation in:||4.1.0-dev|
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. I-10754 I-25769 I-25770 I-25771
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 firstname.lastname@example.org 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 Rev.1552994 Win 7