Sign In/My Account | View Cart  

advertisement

AddThis Social Bookmark Button

Weblog:   Analyzing survey results using OpenOffice.org Calc
Subject:   In response to tedious copying and pasting of the same formula.
Date:   2004-09-17 08:55:57
From:   gregsexton
Click on the cell that your formula is in. You will notice in the bottom right corner of the cell there is a little black square. If you click on this corner and drag as appropriate, it will duplicate your formula and change it appropriately for the new cells.
Full Threads Oldest First

Showing messages 1 through 1 of 1.

  • Jean Hollis Weber photo In response to tedious copying and pasting of the same formula.
    2004-09-17 21:42:31  Jean Hollis Weber | O'Reilly AuthorO'Reilly Blogger [View]

    Unfortunately, in this case, the formula is duplicated without any of the parameters being changed. I assume that's because the program has no way of knowing what to change. -- Jean
Showing messages 1 through 1 of 1.