Unlike Excel, OOo Calc has no real way to have a range cover an entire row or
column. The docs (Help->Spreadsheets->Formulas and Calculations->Calculating
With Formulas) suguest instead to use a very wide range:

=SUM(B1:B65536)  Sums all numbers in column B.

However this can be unsuitable in some cases. If you use the suguested solution
(lets say in cell A1), and extend it to a row below by dragging, the second row
cell (A2) will take a value of "=SUM(B2:B#REF!)", obviously not the desired
result (to keep selecting the entire column).

I would enjoy it if (similar to Excel) omitting the column or row specifier
means select all of the cells. As a variation, omitting only the first or last
means select all from the start until one cell or from a cell onwards (so A2:A
means all column A cells starting at row 2). This would also need to be worked
into the equation editor so you can click a row/column header (If there is a
solution like this, it isn't implemented into the equation editor).