Bug 113398

Summary:	average as sum
Product:	LibreOffice	Reporter:	peekaa <peekaa>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	enhancement	CC:	xiscofauli
Priority:	medium
Version:	unspecified
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	103238
Attachments:	Attachment1 Sum button is not here

Description peekaa 2017-10-24 12:16:27 UTC

Pls make posibility to do Average in the same easy way as Sum. Now you can sum numbers by marking cells and click button Sum (next to Function button in formula bar). The Sum button could be Dropdown menu with second choice Average. Thank you.

Comment 1 Xisco Faulí 2017-10-24 20:19:17 UTC

You can add it yourself using the customize dialog -> https://help.libreoffice.org/Common/Customize
Closing as RESOLVED NOTABUG

Comment 2 peekaa 2017-10-25 07:35:23 UTC

Created attachment 137276 [details]
Attachment1

Comment 3 peekaa 2017-10-25 07:38:07 UTC

Created attachment 137277 [details]
Sum button is not here

Comment 4 peekaa 2017-10-25 07:38:22 UTC

I dont think so. There is no option to edit Formula Bar, it is not in the list Customize, see attachment1. Moreover I have not found neither the button Sum neither Average to be able to add it to any bar..... see attachment2

Comment 5 Thomas Lendo 2017-10-26 00:47:15 UTC

Moving to UNCONFIRMED as that's the correct status.

Comment 6 Xisco Faulí 2017-10-26 22:57:37 UTC

You don't need to add it to the formula bar explicitly, you can add it to another toolbar as well.
I'm sorry but we get hundred of requests like this one all the time. In the end we will end up with a formula bar with many icons, and that's not convenient.
LibreOffice already has the ability to customize the toolbars. Please, use this feature instead.