https://bugs.documentfoundation.org/show_bug.cgi?id=139602
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|7.0.4.2 release |unspecified Keywords| |difficultyBeginner, | |easyHack, skillCpp --- Comment #9 from Eike Rathke <[email protected]> --- (In reply to Heiko Tietze from comment #5) > 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. You are missing a work flow there. The function is applied to the last cells not containing a formula with the same function, or if the last cell has such function then to all cells containing the function, in a contiguous area. For example, in sequence enter A1: 1 A2: 2 A3: hit sigma Sum => =SUM(A1:A2) => 3 A4: 4 A5: 8 A6: hit sigma Sum => =SUM(A4:A5) => 12 A7: hit sigma Sum => =SUM(A6:A6;A3:A3) => 15 With SUM() it works like subtotals and total. (for which in the last case the formula probably should be =SUM(A6;A3) instead, but that's cosmetic detail). > 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. (In reply to Heiko Tietze from comment #8) > Eike, what do you think? 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. -- You are receiving this mail because: You are the assignee for the bug.
