To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=25769
------- Additional comments from [EMAIL PROTECTED] Tue Jan 29 12:58:18 +0000 2008 ------- @drking: > > Calc doesn't allow a multi-selection to be defined as a name > Yes, I know, but the OP said: > > Presently, the only way of defining a non-contiguous named range is > > to enter the range's specification into the 'Assigned to' box > > manually. > which is wrong, isn't it? There isn't a way within Calc. There is. You have to type the sequence, selecting it with mouse is not possible. It depends though how the defined name is used: > Actually a non-contiguous named range imported from Excel does seem to work, > more or less. eg AREAS(mynamedrangefromexcel)>1 INDEX() and AREAS() are two special cases in the sense that they do accept an (area1;area2) argument as reference parameter. A defined name to use with that needs to include the parentheses in its definition, same as in Excel. Functions like SUM() currently do not support multiple ranges as one parameter, therefor the name definition must not include the parentheses, and the sequence of ranges defined is passed to the function as a sequence of parameters, not one parameter with multiple ranges. > > The implementation of the union operator per issue 32341 doesn't > > change that a multi-selection isn't accepted by the Names Define > > dialog. > That's a shame. I was hoping to reduce the number of outstanding issues. Implementation of the operator is calculation engine core and not related to UI mouse selection in dialogs. --------------------------------------------------------------------- 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]
