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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Aug 12 08:17:45 UTC 2021


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 on the CC list for the bug.


More information about the Libreoffice-ux-advise mailing list