Possible Duplicate:

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

I'm using a Sum of a column, and it keeps growing, so I have to update the reference to which cells should be summed.

Can you reference an infinite group of cells?

Let's say:

`SUM(D2:D∞)`

No matter if you use LibreOffice, Excel or any other spreadsheet, your solution may be applied to LibreOffice too.