[Libreoffice-bugs] [Bug 139602] Calc Sigma drop-down menu functions could include [PRODUCT]
https://bugs.documentfoundation.org/show_bug.cgi?id=139602 Eike Rathke changed: What|Removed |Added Status|NEW |ASSIGNED Assignee|libreoffice-b...@lists.free |dhiraj.hol...@gmail.com |desktop.org | -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139602] Calc Sigma drop-down menu functions could include [PRODUCT]
https://bugs.documentfoundation.org/show_bug.cgi?id=139602 --- Comment #15 from Heiko Tietze --- (In reply to Eike Rathke from comment #12) > 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. Eleven items should be manageable. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139602] Calc Sigma drop-down menu functions could include [PRODUCT]
https://bugs.documentfoundation.org/show_bug.cgi?id=139602 --- Comment #14 from Eike Rathke --- And the (now hopefully) correct URL because DumbZilla munges the trailing ! exclamation mark from the URL effectively leading to the parent commit.. https://git.libreoffice.org/core/+/0ec98930888ee9f29032d12185baefc71da8489f%5E%21/ -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139602] Calc Sigma drop-down menu functions could include [PRODUCT]
https://bugs.documentfoundation.org/show_bug.cgi?id=139602 Eike Rathke changed: What|Removed |Added Keywords|difficultyBeginner |difficultyMedium --- Comment #13 from Eike Rathke --- More places to adapt.. sc/source/ui/view/viewfun2.cxx the enum ScAutoSum, and lcl_IsAutoSumData() the switch, and one comparison in ScViewFunc::GetAutoSumArea() (best introduce a proper end value in the enum for that instead of using the last of the "real" values.. so that never needs to be adapted again). For reference see the commit that introduced the dropdown: https://git.libreoffice.org/core/+/0ec98930888ee9f29032d12185baefc71da8489f%5E! (changing difficulty of the EasyHack to medium). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139602] Calc Sigma drop-down menu functions could include [PRODUCT]
https://bugs.documentfoundation.org/show_bug.cgi?id=139602 --- Comment #12 from Eike Rathke --- (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/0603.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.
[Libreoffice-bugs] [Bug 139602] Calc Sigma drop-down menu functions could include [PRODUCT]
https://bugs.documentfoundation.org/show_bug.cgi?id=139602 --- Comment #11 from Colin --- (In reply to Eike Rathke from comment #9) > (In reply to Heiko Tietze from comment #5) > > > As an enhancement idea, how about showing the last used functions in that > > menu? > We already have that in the Name Box, if a formula is started it switches to > the most recently used functions list. > That's an interesting feature I'd never noticed - I'm no touch typist so I look at the keyboard then the cell contents and/or bar. Now I'll add the name box to the focal points. Just looked at the Name box functionality and a thought occurs to me; If the user has already started typing a few characters then perhaps the name box could also produce "smart" suggestions in the same manner as the function wizard. What would be awesome for us relative newbies would be the option/ability to then open one of those selections in the function wizard and not fail the syntax test 60% of the time :)) It has been noted the function wizard presents all the partial matches for those who only have "half an idea" of what they're looking for (doing;)). Let me know if it's worth filing an enhancement request along these lines. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139602] Calc Sigma drop-down menu functions could include [PRODUCT]
https://bugs.documentfoundation.org/show_bug.cgi?id=139602 Heiko Tietze changed: What|Removed |Added Keywords|needsUXEval | Summary|Show the last used |Calc Sigma drop-down menu |functions with the "Sigma" |functions could include |drop-down menu |[PRODUCT] CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org|tion.org, ||mentoring@documentfoundatio ||n.org --- Comment #10 from Heiko Tietze --- (In reply to Eike Rathke from comment #9) > You are missing a work flow there. This is a quite hidden gem. No idea how to make it transparent to understand. > I'm unbiased, if people think having PRODUCT there would be useful then why > not. > > 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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139602] Calc Sigma drop-down menu functions could include [PRODUCT]
https://bugs.documentfoundation.org/show_bug.cgi?id=139602 --- Comment #7 from Colin --- (In reply to Colin from comment #6) > (In reply to Heiko Tietze from comment #5) > > > > As an enhancement idea, how about showing the last used functions in that > > menu? > > +1 from me It would make sense if the last used functions were pertinent to that sheet - not just LOCalc -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139602] Calc Sigma drop-down menu functions could include [PRODUCT]
https://bugs.documentfoundation.org/show_bug.cgi?id=139602 --- Comment #6 from Colin --- (In reply to Heiko Tietze from comment #5) > > As an enhancement idea, how about showing the last used functions in that > menu? +1 from me -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139602] Calc Sigma drop-down menu functions could include [PRODUCT]
https://bugs.documentfoundation.org/show_bug.cgi?id=139602 --- Comment #5 from Heiko Tietze --- Let me put my question into another context. What is the whole menu good for? Just typing "=SUM()" is pretty simple and we have a huge number of function that can't be listed anyway. So it's rather a clue for new users how to interact with the functions bar. Not really useful, with or without more functions. As an enhancement idea, how about showing the last used functions in that menu? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139602] Calc Sigma drop-down menu functions could include [PRODUCT]
https://bugs.documentfoundation.org/show_bug.cgi?id=139602 --- Comment #4 from Colin --- (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.
[Libreoffice-bugs] [Bug 139602] Calc Sigma drop-down menu functions could include [PRODUCT]
https://bugs.documentfoundation.org/show_bug.cgi?id=139602 Heiko Tietze changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #3 from Heiko Tietze --- Why is Product so important to be added to this list? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139602] Calc Sigma drop-down menu functions could include [PRODUCT]
https://bugs.documentfoundation.org/show_bug.cgi?id=139602 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Whiteboard| QA:needsComment| Keywords||needsUXEval CC||libreoffice-ux-advise@lists ||.freedesktop.org --- Comment #2 from Roman Kuznetsov <79045_79...@mail.ru> --- We could add to the widget all important functions but I don't think it's a good idea -1 from me -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139602] Calc Sigma drop-down menu functions could include [PRODUCT]
https://bugs.documentfoundation.org/show_bug.cgi?id=139602 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 139602] Calc Sigma drop-down menu functions could include [PRODUCT]
https://bugs.documentfoundation.org/show_bug.cgi?id=139602 Colin changed: What|Removed |Added Severity|normal |enhancement -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 139602] Calc Sigma drop-down menu functions could include [PRODUCT]
https://bugs.documentfoundation.org/show_bug.cgi?id=139602 --- Comment #1 from Colin --- Created attachment 168873 --> https://bugs.documentfoundation.org/attachment.cgi?id=168873&action=edit Screen dump -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
