Easy Spreadsheet Question

[TIGR]

I'm using OpenOffice.org Calc. It's sad that I have to ask this but spreadsheets are just something I've never used in all my computer-related adventures.

This is very basic and I'm sure someone here can probably answer this quickly. In the meantime I'm reading the documentation. Unfortunately since I'm new to spreadsheets, finding what I need in the mass of documentation is going to take a long time for what is a very basic operation.

I have a database with thousands of rows and two columns (frametimes from Fraps). I only want to operate on column B. Here's what I want to do:

Subtract B1 from B2 and put result in C1.
Subtract B2 from B3 and put result in C2.
Subtract B3 from B4 and put result in C3.

And so on down the line to the last row.

To do it manually, I've done the following:

Click C1 and type =.
Click B2.
Type -.
Click B1 and hit Enter.
Repeat down the line.

How can I automate this?

 

[TIGR]

Info for anyone else who wonders. Got the answer at the OpenOffice.org forum.

With =B2-B1 in C1, any of the following might complete column C...

1 Double click C1's fill handle. C1's fill handle is the little black blob in its bottom-right corner. It is only visible when C1 is the active cell. If all the column B cells from B1 down to the bottom of your data contain values then all of the corresponding column C cells will automatically be filled with the appropriate Bn+1-Bn formula....