https://issues.apache.org/ooo/show_bug.cgi?id=123700
Bug ID: 123700
Issue Type: DEFECT
Summary: Cal does not have the function function AGGREGATE
(function Excel2010)
Product: Calc
Version: 4.0.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: programming
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
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,
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
