[Libreoffice-bugs] [Bug 125272] CALC doesn’t detect an invalid entry for references in the aggregate function

[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
----------------------------------------------------------------------------
                 CC|                            |winfrieddonkers at libreoffice
                   |                            |.org
             Status|NEW                         |NEEDINFO

--- Comment #2 from Winfried Donkers <winfrieddonkers at libreoffice.org> ---
Could you please say exactly what you think is wrong with the function?

What I see in the screen shot you added, I see an expected result.
It is possible to use numeric arguments, references and arrays. AFAIK this also
applies for Excel.

The help file states for this function:
Ref1 – obligatory argument. The first numeric argument (if the range is set by
a list of values inside the function) or a reference to a cell that contains
it. 
Ref2, 3, ... – optional. A numeric argument or a reference to a cell (up to 253
arguments), for which you need the aggregate value.

-- 
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/20190515/2714642b/attachment.html>