[sc-issues] [Issue 109691] Possible bug in MEDIAN() function of OO.o-Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109691 User krewetki changed the following: What|Old value |New value Platform|Unknown |PC Summary|possible bug in MEDIAN() f|Possible bug in MEDIAN() f |unction of OOo Calc |unction of OO.o-Calc Target milestone|--- |OOo 2.4.1 - 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
[sc-issues] [Issue 109691] possible bug in MEDIAN() function of OOo Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109691 User krewetki changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |INVALID --- Additional comments from krewe...@openoffice.org Thu Mar 4 21:37:23 + 2010 --- @tomwb, @discoleo Thanks for your reply. Once you've pointed "sorted ascending" I've noticed I had typed in 227 as the last number whereas I intended to type in 277. If I had done so then OO.o would have given me a correct result. Cheers! P.S. I knew I might have screwed it up but sometimes you just don't notice your silly mistakes... - 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
[sc-issues] [Issue 109691] possible bug in MEDIAN() function of OOo Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109691 Issue #|109691 Summary|possible bug in MEDIAN() function of OOo Calc Component|Spreadsheet Version|OOo 2.4.1 Platform|Unknown URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|krewetki --- Additional comments from krewe...@openoffice.org Sun Feb 28 20:32:56 + 2010 --- Hi, I believe there might be a bug of the MEDIAN() function. When I type in the following values (cells A16:I16) 179 199 202 229 249 263 263 263 227 and the function into J16 which is =MEDIAN(A16:I16) the result is 229, whereas it shall be 249, because "median" is the middle value (or aritmetic mean if the number of numbers is odd). The screenshot is here http://img408.yfrog.com/i/screenshotopenofficeorg.jpg/ Then I type into a cell the following formula: =MEDIAN(179; 199; 202; 229; 249; 263; 263; 263; 227) and the result is 249 which is, again, wrong as it should be 249. The screenshot is here http://yfrog.com/0ascreenshotopenofficeorgj I think I've filled my OO writer version details correctly, but just in case I've done it wrong, here is the screenshot when I go to Help->About OpenOffice.org http://yfrog.com/16screenshotopenofficeorgj Please repair and let me know what should I do to download and successfully install path/new version at Debian Linux. Thank you very much in advance. -- regards, krewetki - 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
