[Libreoffice-bugs] [Bug 139602] Calc Sigma drop-down menu functions could include [PRODUCT]

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from Colin <that.man.colin at gmail.com> ---
(In reply to Heiko Tietze from comment #3)
> Why is Product so important to be added to this list?

It's probably just as relevant as both Min & Max - it returns a result based
upon the calculated value of the whole array. Min & Max just "Cherry Pick" -
not really what one could define as "Array Functions".


The Subtotal()function provides infinitely better control over these Sigma
functions.

Paste special caters for "simple" mathematical operations on the selected cells
and the analysis of selected cells on the status line can be defined to
display, in real-time, the same results as the Sigma functions.

What else is missing from all these pre-defined "array" functions?

-- 
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/20210812/170e239b/attachment.htm>