I'd like to refer to an entire column, like you can in Excel by using
A:A. 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
OFFSET($A$1;0;0;65536;1)as the previous range may get altered if you insert or remove rows.
- Use Data -> Define Range... to name the column range (but which for me still just equates to
These approaches seem over-complicated and still don't achieve my goal perfectly. Does anyone know of a way?