title: Applying a formula to all cells in a column, not just one at a time?
body: <p>In OpenOffice.org Calc, I would like to apply a formula to a column that references a cell from the same row but in a different column. I.e., <code>=C1*48</code> in cell D1, but I want all cells in column D to do this without having to copy the formula to each one manually. Or another way of saying it, for each cell in C that has a number, I want to fill in the corresponding row-cell in D with a formula value based on that number. So far, all I can see from the documentation is that I'd have to copy/adjust the formula for every new row in the spreadsheet. And since I have 4 such columns that need calculation, this will get to be tiresome. I have little experience with spreadsheets at all, so I'm hoping that my problem is actually very simple, and that I just am looking at the wrong parts of the documentation.</p>