To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84667
User drking changed the following: What |Old value |New value ================================================================================ CC|'' |'drking' -------------------------------------------------------------------------------- ------- Additional comments from [EMAIL PROTECTED] Tue Jan 29 08:38:33 +0000 2008 ------- "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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]