Download it now!
Bug 113398 - average as sum
Summary: average as sum
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Customise-Dialog
  Show dependency treegraph
Reported: 2017-10-24 12:16 UTC by peekaa
Modified: 2017-10-26 22:57 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachment1 (61.70 KB, image/png)
2017-10-25 07:35 UTC, peekaa
Sum button is not here (23.44 KB, image/png)
2017-10-25 07:38 UTC, peekaa

Note You need to log in before you can comment on or make changes to this bug.
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 ->
Comment 2 peekaa 2017-10-25 07:35:23 UTC
Created attachment 137276 [details]
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.