To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107509 Issue #|107509 Summary|Wrong rank computation of sum values Component|Spreadsheet Version|OOO310m19 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|twonkeys
------- Additional comments from twonk...@openoffice.org Mon Dec 7 21:10:15 +0000 2009 ------- In two rows, I computed the simple sum of four numbers. Then I computed the rank of these two sum values. Although the sums are identical, the ranks come out as 1 and 2. When comparing the two sums with the "if" function, they are regarded as equal. When copying both rows and subtracting 10 from both of the first values, the ranks come out as 1 and 1 (as expected). I attached a simple sample document, where the sums are marked blue, the ranks yellow and the "if" formulas green. I don't know if it matters, but I'm using OO in its German version. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org