To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105140 Issue #|105140 Summary|12 new functions in excel 2007 not found in calc Component|Spreadsheet Version|version58 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P2 Subcomponent|editing Assigned to|spreadsheet Reported by|walidz
------- Additional comments from wal...@openoffice.org Thu Sep 17 08:23:29 +0000 2009 ------- The following functions found in excel 2007 but not in calc 1- AVERAGEIF(range,criteria,average_range) 2- AVERAGEIFS(average_range,criteria_range1,criteria1, criteria_range2, criteria2…) 3- CUBEKPIMEMBER(connection,kpi_name,kpi_property,caption) 4- CUBEMEMBER(connection,member_expression,caption) 5- CUBEMEMBERPROPERTY(connection,member_expression,property) 6- CUBERANKEDMEMBER(connection,set_expression,rank,caption) 7- CUBESET(connection,set_expression,caption,sort_order,sort_by) 8- CUBESETCOUNT(set) 9- CUBEVALUE(connection,member_expression1,member_expression2…) 10 - COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) 11 - IFERROR(value,value_if_error) 12 - SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …) please refer to excel help , or search google for the usage of these functions --------------------------------------------------------------------- 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