[Libreoffice-bugs] [Bug 139602] Show the last used functions with the "Sigma" drop-down menu

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139602

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|7.0.4.2 release             |unspecified
           Keywords|                            |difficultyBeginner,
                   |                            |easyHack, skillCpp

--- Comment #9 from Eike Rathke <erack at redhat.com> ---
(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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210816/5a9d2181/attachment-0001.htm>