Apache OpenOffice (AOO) Bugzilla – Issue 84667
Range Naming non-consecutive cells
Last modified: 2014-01-10 13:08: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.
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
"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.
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.
reassigning features and enhancements to user requirements@openoffice.org which will be the default owner for those tasks (was introduced some time ago)
This is still true for 3.1
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