https://bugs.documentfoundation.org/show_bug.cgi?id=125272
Winfried Donkers <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Assignee|[email protected] |winfrieddonkers@libreoffice
|desktop.org |.org
Status|REOPENED |ASSIGNED
Summary|CALC doesn’t detect an |CALC doesn’t detect an
|invalid entry for |invalid entry for
|references in the aggregate |references in AGGREGATE and
|function |SUBTOTAL functions
--- Comment #4 from Winfried Donkers <[email protected]> ---
(In reply to Djaafar Benchikh from comment #3)
> the correct format of references is like A1, A2, B1, B2. while in CALC the
> aggregate function gives a result for an incorrect format of references
>
> aggregate(2,4,A1,A5) correcte format
> aggregate(2,4,1,1) incorrect format
Ok, I wrongly interpreted the description of the function in Excel, which says
that argument 3...n represents a numerical value and only the name of the
argument (ref1...refx) suggests that the argument ought to be a reference and
not a numerical value.
I managed to use a computer with Excel and indeed, Excel does not accept
numerical values as arguments.
And as Calc's AGGREGATE is to be fully interoperable with Excel, it will be
necessary to reduce the functionality of AGGREGATE in Calc. Always a pity if
functionality is to be reduced.
The same applies for SUBTOTAL, I changed the bug report's title to reflect
this.
I'll start 'fixing'.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
