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

I think this would be a real usability boost

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 :wink:

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/show_bug.cgi?id=44419

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.

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.

https://bugs.documentfoundation.org/show_bug.cgi?id=97956

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!

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

https://www.libreoffice.org/get-help/bug/

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

This enhancement request is already specified in fdo#44419.

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…

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…

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

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.