Issue 87353

Summary: RANK sometimes gives a rank to text
Product: Calc Reporter: drking <openoffice>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues
Version: OOo 2.3.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

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