Bug 131205

Summary:	Add <Alt> + <=> shortcut in Calc for quick column summing
Product:	LibreOffice	Reporter:	nat_keller
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	enhancement	CC:	79045_79045, erack, heiko.tietze
Priority:	medium
Version:	6.4.1.2 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	98259

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.