<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Calc Sigma drop-down menu functions could include [PRODUCT]" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139602#c12">Comment # 12</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Calc Sigma drop-down menu functions could include [PRODUCT]" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139602">bug 139602</a> from <a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> <pre>(In reply to Heiko Tietze from <a href="show_bug.cgi?id=139602#c10">comment #10</a>) > This is a quite hidden gem. No idea how to make it transparent to understand. <a href="https://help.libreoffice.org/latest/en-GB/text/scalc/02/06030000.html?DbPAR=CALC">https://help.libreoffice.org/latest/en-GB/text/scalc/02/06030000.html?DbPAR=CALC</a> 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 <a href="https://help.libreoffice.org/latest/en-GB/text/scalc/01/04060106.html?DbPAR=CALC#bm_id3165633">https://help.libreoffice.org/latest/en-GB/text/scalc/01/04060106.html?DbPAR=CALC#bm_id3165633</a></pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>