Issue 84476 - ODFF: RANK function with multiple ranges
Summary: ODFF: RANK function with multiple ranges
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.3.1 RC1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ooo
QA Contact: issues@sc
URL:
Keywords: ms_interoperability
Depends on: 32341
Blocks:
  Show dependency tree
 
Reported: 2007-12-11 22:05 UTC by moravia
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

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

Attachments
test file showing problem (216.00 KB, application/vnd.ms-excel)
2007-12-12 03:07 UTC, moravia 		no flags Details
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 moravia 2007-12-11 22:05:42 UTC 
Received file created in MS Excel 2003 that has data in A2:A10 A12:A20 A22:A30.
 Then in B2 is =RANK(A2; (A2:A10,A12:A20,A22:A30), 1) which shows as Err:508 but
works in Excel.  The gaps are due to summary values in the other rows. 
Incidentally, if I remove the extra rows and make the formula
=RANK(A2;A2:A200,1) I do not even get the right answer!  (There is no number 1
rank; it starts at 3 and ends 2 higher than the number of entries.)
Comment 1 frank 2007-12-11 22:20:18 UTC 
Please attach a file showing your problem.

Frank
Comment 2 moravia 2007-12-12 03:07:47 UTC 
Created attachment 50246 [details]
test file showing problem
Comment 3 moravia 2007-12-12 03:10:47 UTC 
I think the rank number starting at 3 had to do with me using $A$1:$A$230 when
the data really started at $A$7.  That part is at least resolved (testing in
Linux; assuming it will work the same in Windows.)  Test file created in OOo
2.3.0-6.4.fc7 based on data from the original file.
Comment 4 frank 2007-12-12 12:44:22 UTC 
Hi Eike,

as you told me, multiple ranges are not possible at this time, so this is
re-flagged as enhancement and targeted to 3.x.

Frank
Comment 5 ooo 2007-12-12 13:09:28 UTC 
Range lists aka union operator (in Excel (range1,range2,...)) aren't supported
yet. ODFF relevant, interoperability.
Comment 6 ooo 2008-03-03 12:36:55 UTC 
This was actually implemented with issue 32341.
Comment 7 ooo 2008-03-03 12:44:47 UTC 
Verified in CWS build.
Comment 8 ooo 2008-05-30 17:16:36 UTC 
Present in master, closing.