fdo70798 Add Excel 2010 functions to Calc

[Eike Rathke]

Hi Winfried,

On Monday, 2014-04-14 13:03:40 +0200, Winfried Donkers wrote:

> AFAICS there's only one Excel 2010 function left to be added to Calc: AGGREGATE.

Yup :-)  At least of those statistics functions we identified..

> I can add this function with partial functionality: all aggregate functions will be available, but the various filter options will not all be implemented.
> I think this way most of the functionality will be available in Calc.

That would be a starting point.

> The remaining filtering options will take some time, I reckon, as I don't think the current code is prepared for these options.

Just make sure that if a filter option is not supported the function
returns an error in that case.

For the "ignore errors" options we'll have to provide either an option
to existing subfunctions or implement their counterparts (depends on
complexity).

"Ignore nested SUBTOTAL and AGGREGATE functions" is similar to SUBTOTAL
with the addition of AGGREGATE.

"Ignore hidden rows" is somewhat similar to how it is handled in
SUBTOTAL, just that SUBTOTAL ignores only filtered rows in the first set
of its options, not all hidden. Actually needs to be clarified if Excel
really ignores all hidden or only filtered. SUBTOTAL has a second set of
options that ignores not only filtered rows but all hidden rows, we also
need to implement that, so AGGREGATE may benefit from it.

  Eike

-- 
LibreOffice Calc developer. Number formatter stricken i18n transpositionizer.
GPG key ID: 0x65632D3A - 2265 D7F3 A7B0 95CC 3918  630B 6A6C D5B7 6563 2D3A
Support the FSFE, care about Free Software! https://fsfe.org/support/?erack
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 819 bytes
Desc: not available
URL: <http://lists.freedesktop.org/archives/libreoffice/attachments/20140414/99c75164/attachment.sig>