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

1. Use A1:A65536.
2. Use OFFSET($A$1;0;0;65536;1) as the previous range may get altered if you insert or remove rows.
3. Use Data -> Define Range... to name the column range (but which for me still just equates to $A$1:$A$1048576).

These approaches seem over-complicated and still don't achieve my goal perfectly. Does anyone know of a way?

Thanks,

Andy