[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 #12 from Eike Rathke <erack at redhat.com> ---
(In reply to Heiko Tietze from comment #10)
> This is a quite hidden gem. No idea how to make it transparent to understand.
https://help.libreoffice.org/latest/en-GB/text/scalc/02/06030000.html?DbPAR=CALC
maybe could explain better.

> > Every entry of sc/uiconfig/scalc/ui/autosum.ui needs handling in
> > sc/source/ui/app/inputwin.cxx ScInputWindow::MenuHdl() but that should be
> > easy enough to make this an EasyHack. Doing so.
> 
> Thanks for the code pointer, adding PRODUCT wont hurt.
One more to comply with: in a filtered area the SUBTOTAL() function with a
function index is inserted instead of SUM(), ... to correctly calculate
filtered rows. In sc/source/ui/view/viewfun2.cxx GetSubTotal() needs to be
adapted as well. The function index for PRODUCT is 6.

While at it, maybe all remaining known SUBTOTAL() functions could be added, on
the other hand I'm not sure that's actually needed or wouldn't overcrowd the
list. See
https://help.libreoffice.org/latest/en-GB/text/scalc/01/04060106.html?DbPAR=CALC#bm_id3165633

-- 
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/20210816/9ccfe3a5/attachment.htm>