Download it now!
Bug 131205 - Add <Alt> + <=> shortcut in Calc for quick column summing
Summary: Add <Alt> + <=> shortcut in Calc for quick column summing
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.1.2 release
Hardware: All Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Shortcuts-Accelerators
  Show dependency treegraph
 
Reported: 2020-03-07 15:10 UTC by nat_keller
Modified: 2020-05-04 13:31 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description nat_keller 2020-03-07 15:10:11 UTC
This would be an enhancement in Calc - not a bug. (I can't seem to find anything that sends me to an enhancement page.)

I've just recent left excel behind having retired recently. I've used excel for years.

In excel if one held the "alt" key and hit the "=" key at the bottom of a column of numbers - the sum of that column would be calculated.

I'd love to have that functionality in Calc.

thanks
Nat Keller
Comment 1 Karl 2020-03-08 10:50:16 UTC
Hi,

Select your coloumn in the coloumn letter on top

status line on bottom gives you sum and average

regards
Comment 2 nat_keller 2020-03-08 13:22:30 UTC
(In reply to Karl from comment #1)
> Hi,
> 
> Select your coloumn in the coloumn letter on top
> 
> status line on bottom gives you sum and average
> 
> regards



Well aware of that. 

"Alt"+"=", in excel, actually puts the function (=sum(...) ) for the highlited column in the cell.
Comment 3 Roman Kuznetsov 2020-04-30 22:07:03 UTC
Heiko, can you give me a code point for our shortcuts in Calc?

I see this question very often. And really I think we can just add that shortcut by default. What do you think?
Comment 4 Heiko Tietze 2020-05-04 10:03:52 UTC
I presume the function takes all values from bottom to top until an empty cell. For example:
A1 1
A2
A3 1
A4 1
alt+= at A5 creates =sum(A4,A5)

(In reply to Roman Kuznetsov from comment #3)
> Heiko, can you give me a code point for our shortcuts in Calc?

Not sure that this is an easyhack. It's not a question of shortcuts but selection.
Comment 5 Heiko Tietze 2020-05-04 10:05:38 UTC
Another question:
A1 1
A2 A
A3 1
A4 1

Do non-numeric cells interrupt the selection [=sum(A4,A5)] or are they just ignored [=sum(A1,A4,A5)]?
Comment 6 Eike Rathke 2020-05-04 12:27:06 UTC
As I see it the Alt+= would just be a shortcut for the Sigma (Sum) toolbar button (anything else would be utterly confusing), which in the described case produces =SUM(A3:A4) thus stopping at a non-numeric cell content.
Comment 7 Eike Rathke 2020-05-04 12:28:51 UTC
Oh, if previous to hitting the button the range A1:A4 was already selected then the formula is =SUM(A1:A4)
Comment 8 Heiko Tietze 2020-05-04 13:31:58 UTC
Yes, the sum() function (.uno:AutoSum) is exactly what Nat is looking for. And you should customize the shortcut yourself (Tools > Customize > Keyboard) as the equal symbol is located at shift+0 on a German keyboard.

Equal is missing yet but if you desperately need to customize it, we can add it to the list. Closing for now as WFM.