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
Hi, Select your coloumn in the coloumn letter on top status line on bottom gives you sum and average regards
(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.
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?
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.
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)]?
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.
Oh, if previous to hitting the button the range A1:A4 was already selected then the formula is =SUM(A1:A4)
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.