To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101995
User regina changed the following: What |Old value |New value ================================================================================ CC|'' |'regina' -------------------------------------------------------------------------------- Ever confirmed| |1 -------------------------------------------------------------------------------- Status|UNCONFIRMED |NEW -------------------------------------------------------------------------------- Keywords| |oooqa -------------------------------------------------------------------------------- ------- Additional comments from reg...@openoffice.org Sun May 17 21:02:21 +0000 2009 ------- In MIN you use IF(MONTH(B$10:B$19)=5;C$10:C$19;0) which sets the result to 0, if MONTH() unequal 5. Therefore the minimum is 0. In SMALL you use IF(MONTH($B$10:$B$19)=5;C$10:C$19) which is a form with only two parameters. It sets the result to the default FALSE, if MONTH() unequal 5. Therefore the smallest is 28. =MIN(IF(MONTH($B$10:$B$19)=5;C$10:C$19)) will work as =SMALL(IF(MONTH($B$10:$B$19)=5;C$10:C$19);1) But the question is, why FALSE is not evaluated as 0 in array context. I set this issue to new, so that Eike can look, whether this is conform to ODF spec. --------------------------------------------------------------------- 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