FG
💻 Software

Can you reference an entire column in OpenOffice Calc (like A:A in Excel)?

Fresh7 days ago
Mar 15, 202626326 views
Confidence Score0%
0%

Problem

I'd like to refer to an entire column, like you can in Excel by using . I found a discussion on the openoffice.org forums which is a few years old, and suggests there is/was no neat way to do it. The options presented are Use . Use as the previous range may get altered if you insert or remove rows.…

Error Output

A:A

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Can you reference an entire column in OpenOffice Calc (like A:A in Excel)?

Low Risk

You can make it less complicated by naming the column. Select the column and name it via the Name Box near the upper-left corner of Calc. You can't use A:A, but AA will work. This is similar to #3 above. It seems to handle insert/delete of rows fine…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment