Issue 87353 - RANK sometimes gives a rank to text
Summary: RANK sometimes gives a rank to text
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.3.1
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-03-23 19:07 UTC by drking
Modified: 2013-01-29 21:42 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description drking 2008-03-23 19:07:05 UTC
In A1:A3 we have 0, 1, dog

RANK(A3;A1:A3) returns 2

change A1 to 1 and
RANK(A3;A1:A3) returns #VALUE!

Excel returns #VALUE! in both cases.

Happily Calc does *not* change the ranking of other numbers in either case. The 
text is still ignored, so this is a minor issue.

However (probably not relevant but interesting) Excel (97) has very similar odd 
behaviour with logical values (it includes TRUE only if there is another 1 in 
the numberlist). Calc always includes logical values.
Comment 1 amy2008 2008-09-01 04:24:26 UTC
Can reproduce it in the OOo300_m3_EN on WinXP.
It is just related to zero