To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87353 Issue #|87353 Summary|RANK sometimes gives a rank to text Component|Spreadsheet Version|OOo 2.3.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|programming Assigned to|spreadsheet Reported by|drking
------- Additional comments from [EMAIL PROTECTED] Sun Mar 23 18:07:05 +0000 2008 ------- 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. --------------------------------------------------------------------- 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]
