Issue 123700

Summary:	Calc does not have the function AGGREGATE (function Excel2010)
Product:	Calc	Reporter:	papayes <jyl44>
Component:	programming	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Normal
Priority:	P3	CC:	issues, rb.henschel
Version:	4.0.1
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

Description papayes 2013-11-17 08:17:11 UTC

Hello,
The Excel 2010 version has some new features that are now with AOO 4. The Aggregate (or Agregat in French) function does not appear. This new function, high performance, can perform complex calculations, using a few simple parameters.
=AGGREGATE(function_num,options,ref1,ref2) or 
=AGGREGATE(function_num,options,array) 
(Function_num Required. A number 1 to 19 that specifies which function to use
as AVERAGE{1}, SUM{9}, MAX{4}, etc.) 
AGGREGATE function
Returns an aggregate in a list or database. The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values.
http://office.microsoft.com/en-us/excel-help/aggregate-function-HA010338704.aspx
Sincerely,

Comment 1 Regina Henschel 2013-11-17 09:42:23 UTC

Valid request. Some remarks:

The function AGGREGATE is not defined in ODF1.2. So it has to be implemented with our own namespace.

The function AGGREGATE is an extension to the function SUBTOTAL. SUBTOTAL is missing some parameter values, see bug 35718. Developers should treat that bug together with this.