• We've upgraded our forums. Please post any issues/requests in this thread.

Easy Spreadsheet Question

Joined
Aug 17, 2008
Messages
2,184 (0.64/day)
Likes
1,027
Location
Minnesota, USA
System Name TIGRAlpha4
Processor i5 750 @ 3.6GHz
Motherboard ASRock P55 Deluxe
Cooling S1283 + FFB1212VHE
Memory 16GB DDR3 1800, 7-8-7-24
Video Card(s) 560 Ti
Storage 128GB Kingston SSD + 16TB RAID 6
Display(s) Dell P1130 + Samsung 275T
Case Antec Twelve Hundred
Power Supply Silverstone OP1000-E
#1
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?
 
Joined
Aug 17, 2008
Messages
2,184 (0.64/day)
Likes
1,027
Location
Minnesota, USA
System Name TIGRAlpha4
Processor i5 750 @ 3.6GHz
Motherboard ASRock P55 Deluxe
Cooling S1283 + FFB1212VHE
Memory 16GB DDR3 1800, 7-8-7-24
Video Card(s) 560 Ti
Storage 128GB Kingston SSD + 16TB RAID 6
Display(s) Dell P1130 + Samsung 275T
Case Antec Twelve Hundred
Power Supply Silverstone OP1000-E
#2
Info for anyone else who wonders. Got the answer at the OpenOffice.org forum.

ken johnson said:
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....