[Libreoffice-bugs] [Bug 125272] CALC doesn’t detect an invalid entry for references in AGGREGATE and SUBTOTAL functions

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125272

Winfried Donkers <winfrieddonkers at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Assignee|libreoffice-bugs at lists.free |winfrieddonkers at 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 <winfrieddonkers at libreoffice.org> ---
(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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190516/81a1eacd/attachment.html>