Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


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

Attachment: pgpg_0LXVsZEJ.pgp
Description: PGP signature


Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.