To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103981 Issue #|103981 Summary|MAX(), MIN() and AVERAGE() do not work with #N/A value |s Component|Spreadsheet Version|OOO310m11 Platform|All URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|fda
------- Additional comments from [email protected] Mon Aug 3 19:49:09 +0000 2009 ------- If a dataset contains a cell with a #N/A value (meaning that no data is available), functions such as MIN(), MAX() and AVERAGE() gives #N/A, just like if MIN, AVERAGE and MAX could not be computed. Indeed, a cell with "No Data Available" should be discarded, just like an empty cell is discarded (compare exemples 1, 2 and 3) Note 1: Functions related to standard deviation gives weird results if one cell contains the #N/A value. It looks like cells after the #N/A value are not considered. Note 2: Function such as NB() work properly, i.e. NB() does not count empty cells nor #N/A values. Exemple 1: all cells are numbers 1 2 3 4 5 MIN() gives 1; AVERAGE() gives 3; MAX() gives 5 (==> OK) Exemple 2: one cell is empty 1 2 4 5 MIN() gives 1; AVERAGE() gives 3; MAX() gives 5 (==> OK) Exemple 3: one cell is set to NO_DATA 1 2 =na() 4 5 MIN() gives #N/A; AVERAGE() gives #N/A; MAX() gives #N/A (==> Not OK) --------------------------------------------------------------------- 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]
