Bug Hunting Session
Bug 86091 - TOOLBAR: Change Sum button in Formula Bar into split button
Summary: TOOLBAR: Change Sum button in Formula Bar into split button
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Split-Group-Buttons Calc-Formula-Bar
  Show dependency treegraph
 
Reported: 2014-11-10 06:25 UTC by Yousuf Philips (jay) (retired)
Modified: 2017-06-21 13:03 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
toolbar drop down in Quattro Pro (6.10 KB, image/png)
2014-11-12 16:08 UTC, Yousuf Philips (jay) (retired)
Details
function split button in Excel (9.83 KB, image/png)
2017-06-21 12:51 UTC, Yousuf Philips (jay) (retired)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Yousuf Philips (jay) (retired) 2014-11-10 06:25:06 UTC
It would be useful to have the 'Sum' button as a group button with a drop down list of other commonly used functions like AVERAGE, COUNT, MAX, MIN, and the last entry being 'more functions', which opens the function wizard.
Comment 1 Cor Nouws 2014-11-10 10:36:32 UTC
Hi Jay,

OK, but adding 'more function' is the same as the nice icon that is left of the Sum, so IMO superfluous.
Cheers
Cor
Comment 2 Yousuf Philips (jay) (retired) 2014-11-10 16:48:36 UTC
Hi Cor,

Well i was going to suggest disabling that button, but not sure how people would react to that. :D
Comment 3 Cor Nouws 2014-11-10 19:37:48 UTC
Hi Jay,

I see no need to change that. It's a beautiful icon, room enough, and a distinctive visual element, and oh yes: fast access for those clicking :)
Comment 4 Yousuf Philips (jay) (retired) 2014-11-11 01:12:46 UTC
(In reply to Cor Nouws from comment #3)
> I see no need to change that. It's a beautiful icon, room enough, and a
> distinctive visual element, and oh yes: fast access for those clicking :)

True :D
Comment 5 Yousuf Philips (jay) (retired) 2014-11-12 16:08:48 UTC
Created attachment 109355 [details]
toolbar drop down in Quattro Pro
Comment 6 Eike Rathke 2017-06-20 22:39:39 UTC
Adding other functions doesn't make much sense if you take the special handling into account that the Sum button provides, differentiating between mere data above or data interspersed with other SUM formula cells. I suggest to drop this idea.
Comment 7 Yousuf Philips (jay) (retired) 2017-06-21 12:51:12 UTC
Created attachment 134193 [details]
function split button in Excel
Comment 8 Yousuf Philips (jay) (retired) 2017-06-21 13:03:26 UTC
(In reply to Eike Rathke from comment #6)
> Adding other functions doesn't make much sense if you take the special
> handling into account that the Sum button provides, differentiating between
> mere data above or data interspersed with other SUM formula cells.

The special handling of auto selecting the range that happens when clicking the Sum button is a good feature and if the function in the list can benefit from the feature, it should auto select the range, but if it doesnt, then it should simply insert the function into the cell, just like it would simply insert '=SUM()' into a field that isnt near a range.