1. Welcome to TechPowerUp Forums, Guest! Please check out our forum guidelines for info related to our community.

Easy Spreadsheet Question

Discussion in 'General Software' started by TIGR, Oct 27, 2010.

  1. TIGR

    Joined:
    Aug 17, 2008
    Messages:
    2,183 (1.00/day)
    Thanks Received:
    1,029
    Location:
    Minnesota, USA
    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?
  2. TIGR

    Joined:
    Aug 17, 2008
    Messages:
    2,183 (1.00/day)
    Thanks Received:
    1,029
    Location:
    Minnesota, USA
    Info for anyone else who wonders. Got the answer at the OpenOffice.org forum.

    mikeh, danik, drdaver and 2 others say thanks.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guest)

Share This Page