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

I think this would be a real usability boost

First time here? Check out the FAQ!

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

I think this would be a real usability boost

close date 2020-08-23 09:55:40.347656

4

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.

2

As longs as you have a fairly recent version (roughly newer than 4.0.4.2) 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!

1

This enhancement request is already specified in fdo#44419.

1

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

0

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...

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...

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.

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

Seen: **21,474 times**

Last updated: **Jul 30 '15**

To display two cells contents together in another cell [closed]

Displaying formulas from horizontal block of cells to vertical block of cells [closed]

Calc cells shows only formula and not product/output [closed]

How can I expand a chart's data range? [closed]

seeking clarification of range name scope in Calc [closed]

Alternating table column numbering, Col1 Numbers, Col2 Letters? [closed]

How do I export a chart in an image format from LibreOffice Calc? [closed]

Are there plans for a "papercut" project for libreoffice [closed]

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.

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 ;)

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.

will be available in a future version: https://bugs.documentfoundation.org/s...