Download it now!
Bug 39302 - Shortcut Key: alt += hot key for autosum
Summary: Shortcut Key: alt += hot key for autosum
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.0 RC2
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
: 92533 (view as bug list)
Depends on:
Blocks: Shortcuts-Accelerators
  Show dependency treegraph
Reported: 2011-07-17 05:50 UTC by Vijay
Modified: 2019-07-28 14:33 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Vijay 2011-07-17 05:50:11 UTC
It will be very handy if you assign (alt + =) hot key for autosum as in EXCEL.

This will be very useful as autosum function is used most.


With Regards

Comment 1 Rainer Bielefeld Retired 2011-07-17 22:38:37 UTC
What the heck is "autosum"?
Comment 2 Rainer Bielefeld Retired 2011-07-18 02:24:37 UTC
Autosum is not a term in LibO.
We are talking about the function done by the Sigma Σ in the Formula Bar.
I cant see big advantage using such a shortcut, but UI so seems to be incomplete. 
We never had a shortcut in LibO, so Version -> 3.3.0

Usability / Accessibility aspects?

The related OOo bug is 45563 -  Request keyboard shortcut for AutoSum

Sounds like an EasyHack
Comment 3 Björn Michaelsen 2011-12-23 13:25:37 UTC
Since all new unconfirmed bugs start in state UNCONFIRMED now and old unconfirmed bugs were moved to NEEDINFO with a explanatory comment, all bugs promoted above those bug states to NEW and later are automatically confirmed making the CONFIRMED whiteboard status redundant. Thus it will be removed.
Comment 4 grofaty 2013-02-14 07:29:09 UTC
I would also really need this shortcut. I am constantly copying text from test file and autosum the column.

If this is really a "easy hack", can someone please add it to the list:
Comment 5 Crusader 2015-03-15 02:34:09 UTC
This request is almost 4 years old.  Even the faintest hope is fast fading. Please make this "EasyHack" happen: it will add value to an already great product.
Comment 6 raal 2015-07-04 04:55:59 UTC
*** Bug 92533 has been marked as a duplicate of this bug. ***
Comment 7 DorothyD 2017-07-05 00:38:40 UTC
There should be at least more than one way of using "autosum". Or the user should be able to change the way he gets to the sigma icon. I for one couldn't change the location of the icon from the formula toolbar, nor move it to another toolbar, nor move it to a menu or submenu.
If it was possible to move it to a menu or to another toolbar then the user could decide to assign keyboard shortcut to it if he wanted, just like for other commands on the toolbars and menus.
But he should not be locked with the icon in only one possible position and only one way of activating it (by moving the mouse to the formula toolbar and clicking the icon.)
I think you should also be able to change the sigma icon to another one, as I reckon this sigma icon is used for more than one thing.
Comment 8 bill 2019-07-04 01:05:40 UTC
Almost 8 years later and this bug/feature request is still unresolved.  

I would have thought that having a very commonly used function not available as a keyboard shortcut, or indeed any way, other than mouse clicking a GUI element would be an issue for universal accessibility of LibreOffice.

I hope it is resolved soon.