https://bugs.documentfoundation.org/show_bug.cgi?id=139602
--- Comment #12 from Eike Rathke <[email protected]> --- (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.
