Ask Your Question

Please allow shorthand referencing of entire columns in calc, eg =sum(a:a) [closed]

asked 2013-07-31 10:27:48 +0200

calcman gravatar image

updated 2013-07-31 13:37:42 +0200

oweng gravatar image

I think this would be a real usability boost

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-23 09:55:40.347656


it would be useful, I agree... specially because I was used to it in Excel... in LibreOffice I had to invest some time to change that habbit ;)

Ljiljan gravatar imageLjiljan ( 2013-08-01 08:20:24 +0200 )edit

I was use Lotus-123 since 1987, Lotus Symphony since 1991, Change to Lotus 123 for Windows since 1996, MS Excel since version 2000, and now use both Excel and LO 4. I know that new feature must be a great advantage.

Paijo gravatar imagePaijo ( 2013-08-02 08:04:25 +0200 )edit

will be available in a future version:

endolith gravatar imageendolith ( 2015-09-13 19:52:06 +0200 )edit

5 Answers

Sort by » oldest newest most voted

answered 2015-07-30 19:07:07 +0200

Kunjomachen gravatar image

From version 5.0., It is possible to specify references to entire columns or rows using the A:A or 1:1 notation instead of A1:A1048576 or A1:AMJ1.

edit flag offensive delete link more


It doesn't work for conditional formatting,though. It just becomes A1:A1048576 and then when you swap rows, the conditional formatting is broken. Every. Time.

endolith gravatar imageendolith ( 2018-07-31 06:42:34 +0200 )edit

answered 2014-03-26 04:59:38 +0200

bostonvaulter gravatar image

As longs as you have a fairly recent version (roughly newer than you can set the formula settings to "Excel A1" (tools>options>formula>calc>formula>formula syntax) to get this support!

Then =sum(A:A) will work!

edit flag offensive delete link more

answered 2013-07-31 13:38:18 +0200

oweng gravatar image

This enhancement request is already specified in fdo#44419.

edit flag offensive delete link more

answered 2013-07-31 12:34:37 +0200

ROSt52 gravatar image

@calcman - If you like you can always place an enhancement request under:

edit flag offensive delete link more


And if possible check for already existing similar requests beforehand... see other answers; anyway, this is now implemented for 5.0

erAck gravatar imageerAck ( 2015-07-30 22:59:21 +0200 )edit

answered 2013-08-01 07:47:19 +0200

L-user gravatar image

You can always write formula: =SUM(A1:A1048576) if you need. But it would be interesting to know why someone needs such a formula. I have been using spreadsheets for ages but have never needed such a formula...

edit flag offensive delete link more


you don write that formula, but select entire column :) that is so good about it... you just write =sum( and then select entire column from column headers... I find it very useful.

Ljiljan gravatar imageLjiljan ( 2013-08-01 08:21:30 +0200 )edit

It allows for a more business orientated logic rather than programming logic.

=sum(a:a) makes a hell of a lot more sense in terms of "just give me a total for the column". When making a spreadsheet, you often use this with portability in mind. Remember, spreadsheets are a business tool...

Nevyn38 gravatar imageNevyn38 ( 2013-11-12 03:31:26 +0200 )edit

The reason I use this is because the correct replacement is =SUM(A$1:A$1048576). Dollar signs are not necessary on a full column reference.

fulldecent gravatar imagefulldecent ( 2015-05-20 17:34:35 +0200 )edit

Question Tools

1 follower


Asked: 2013-07-31 10:27:48 +0200

Seen: 21,498 times

Last updated: Jul 30 '15