Issue 116564 - RANK request for non-contiguous data select with ctrl mouse click
Summary: RANK request for non-contiguous data select with ctrl mouse click
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO320m18
Hardware: PC Windows 7
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2011-01-22 17:22 UTC by demongolem
Modified: 2013-01-29 21:39 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description demongolem 2011-01-22 17:22:17 UTC 
The second argument of the RANK function is a numberlist.  Whereas in other
portions of Calc you can do a control-shift to select non-contiguous items, this
feature does not apply to numberlists.  It would be very useful to select
non-contiguous lists for the RANK function.  I do not consider copy and pasting
in some spare area or new sheet of my spreadsheet to be an acceptable solution
all the time.
Comment 1 Regina Henschel 2011-01-22 20:46:16 UTC 
The second parameter of the RANK function is a NumberSequenceList (as in a lot
of other functions). Such list will be converted from a ReferenceList. A
ReferenceList is build from references which are concatenated with the Operator ~.
For example for getting the RANK of 7 in the numbers in A1:B3 and C7:C10 you can use
=RANK(7;A1:B3~C7:C10)

Do you request, that when using Ctrl plus mouse drag, the operator ~ is inserted
automatically? Or what behavior do you request? Please be aware, that the syntax
of functions is bound to the ODF specification.
Comment 2 demongolem 2011-01-22 21:50:38 UTC 
Yes, I was unaware of the ~ operator in OO3.  That helps me some.  I think it
would be easier to mouse click to select the required cells.  So I request a
control/mouse click combination in this situation.
Comment 3 Regina Henschel 2011-01-22 22:34:41 UTC 
requirement