Issue 123700 - Calc does not have the function AGGREGATE (function Excel2010)
Summary: Calc does not have the function AGGREGATE (function Excel2010)
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: 4.0.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-11-17 08:17 UTC by papayes
Modified: 2013-11-17 09:42 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
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.