Bug 39302 - Shortcut Key: alt += hot key for autosum
Summary: Shortcut Key: alt += hot key for autosum
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 RC2
Hardware: Other All
: medium enhancement
Assignee: Martin van Zijl
URL:
Whiteboard: target:7.1.0 target:7.0.0.1
Keywords:
: 92533 (view as bug list)
Depends on:
Blocks: Shortcuts-Accelerators
  Show dependency treegraph
 
Reported: 2011-07-17 05:50 UTC by Vijay
Modified: 2021-12-14 13:19 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Video demo of patch. (345.14 KB, image/gif)
2020-05-17 17:45 UTC, Martin van Zijl
Details

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.

Thanks

With Regards

(Vijay)
Comment 1 Rainer Bielefeld Retired 2011-07-17 22:38:37 UTC
@reporter:
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?
<http://www.libreoffice.org/get-help/accessibility/#_Keyboard%20Navigation>

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:
https://wiki.documentfoundation.org/Development/Easy_Hacks_by_Difficulty
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.
Comment 9 Martin van Zijl 2020-05-17 17:41:17 UTC
I have just submitted a patch for this to Gerrit.
Comment 10 Martin van Zijl 2020-05-17 17:45:37 UTC
Created attachment 160941 [details]
Video demo of patch.

Here is a video demo of the patch. I press "Alt + =" to trigger the autosum, and then Enter to finalize.
Comment 11 Commit Notification 2020-05-28 14:06:48 UTC
Martin van Zijl committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/fef7a9e67b44c2c269f25ee211c3efd01d215a47

tdf#39302 add "alt + =" shortcut for autosum

It will be available in 7.1.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 12 Eike Rathke 2020-05-28 14:33:29 UTC
Pending CI build https://gerrit.libreoffice.org/c/core/+/94964 for 7-0
Comment 13 Commit Notification 2020-05-28 17:04:25 UTC
Martin van Zijl committed a patch related to this issue.
It has been pushed to "libreoffice-7-0":

https://git.libreoffice.org/core/commit/c44ea3d7d55bc309a078fb01a09994e6098c3ff4

tdf#39302 add "alt + =" shortcut for autosum

It will be available in 7.0.0.1.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 14 Leandro Martín Drudi 2020-07-19 01:03:16 UTC
Don't work:
Version: 7.0.0.2 (x64)
Build ID: c01aa64b6c3d89ebe5fe69c28c7adb24eb85249c
Subprocs. CPU: 8; SO: Windows 10.0 Build 19041; Repres. IU: Skia/Vulkan; VCL: win
Locale: es-AR (es_AR); Interfaz: es-ES
Calc: CL

The keyboard is configured like Español (España) (Spanish (Spain))
Comment 15 Martin van Zijl 2020-08-05 18:59:23 UTC
(In reply to Leandro Martín Drudi from comment #14)
> Don't work:
> Version: 7.0.0.2 (x64)
> Build ID: c01aa64b6c3d89ebe5fe69c28c7adb24eb85249c
> Subprocs. CPU: 8; SO: Windows 10.0 Build 19041; Repres. IU: Skia/Vulkan;
> VCL: win
> Locale: es-AR (es_AR); Interfaz: es-ES
> Calc: CL
> 
> The keyboard is configured like Español (España) (Spanish (Spain))

Have you tried with both the left and right Alt key?

Do other shortcuts with the Alt key work for you? E.g.:

    Alt + PageDown -- should move the cursor one page to the right
    Alt + PageUp -- should move the cursor one page to the left
Comment 16 Viktor 2020-09-02 10:40:55 UTC
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
◘ @Work:
Version: 7.0.1.2 (x64)
Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
CPU threads: 8; OS: Windows 10.0 Build 19041; UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
◘ @HOME:
Version: 7.0.1.2 (x64)
Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
for me it also not working, neither at home nor at work
German keyboard Layout.
Short cuts like:
► Alt + PageDown
► Alt + PageUp
are working fine
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Comment 17 Martin van Zijl 2020-09-08 21:22:54 UTC
(In reply to Viktor from comment #16)

> for me it also not working, neither at home nor at work
> German keyboard Layout.
> Short cuts like:
> ► Alt + PageDown
> ► Alt + PageUp
> are working fine

Thanks for reporting. Seems like this is a locale-related issue.

I tested by switching to German keyboard layout on Ubuntu, and found the following:

1) Using the *Left* Alt key, I press Alt+Shift+0 and the shortcut works OK.
2) Using the *Right* Alt key (AltGr), the shortcut does not work, and I get a "°" symbol instead.

Can you please let me know, does the same happen for you?
Comment 18 LeroyG 2021-05-09 18:57:32 UTC
(In reply to Leandro Martín Drudi from comment #14)
> Don't work:
> Version: 7.0.0.2 (x64)
> Build ID: c01aa64b6c3d89ebe5fe69c28c7adb24eb85249c
> Subprocs. CPU: 8; SO: Windows 10.0 Build 19041; Repres. IU: Skia/Vulkan;
> VCL: win
> Locale: es-AR (es_AR); Interfaz: es-ES
> Calc: CL
> 
> The keyboard is configured like Español (España) (Spanish (Spain))

In Spanish keyboard layout you get "=" with "Shift+0". So, not working for me. Nor "Alt+Shift+0".

Version: 7.0.6.2 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win
Locale: es-MX (es_ES); UI: en-US
Calc: CL

Excuse me if REOPENED Status is not the correct.
Comment 19 Stéphane Guillou (stragu) 2021-12-14 13:17:37 UTC
I am setting this one back to fixed because the enhancement was implemented. To keep things tidy and focused, please open a new bug report of issues with this shortcut not working for specific locales or keyboard layouts (if the issue still exists in a recent version of LibreOffice).
Comment 20 Stéphane Guillou (stragu) 2021-12-14 13:19:53 UTC
I should mention that this is verified as fixed in:

Version: 7.3.0.0.beta1 / LibreOffice Community
Build ID: 436f14c25ec1847646b953cf13d0db4f7ca3be57
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Version: 7.2.4.1 / LibreOffice Community
Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Version: 7.1.8.1 / LibreOffice Community
Build ID: e1f30c802c3269a1d052614453f260e49458c82c
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded