TJ111
01-15-2008, 04:20 PM
Just wondering how to retrieve information regarding the location of the current cell in OpenOffice. I want to dynamically retrieve values of relative cells and be able to move the location of the cell without having to rewrite the formula in it.
For example if I wanted cell B2 to be:
=(SUM(b3;b4)) - (b6-b5)
If I moved the same code to col C I'd have to change it to:
=(SUM(c3;c4)) - (c6-c5)
And the same for every subsequent cell. There's gotta be a way to access the cell row/col information about a cell and use that in a function. I just can't seem to find the magic google keywords. Thanks.
For example if I wanted cell B2 to be:
=(SUM(b3;b4)) - (b6-b5)
If I moved the same code to col C I'd have to change it to:
=(SUM(c3;c4)) - (c6-c5)
And the same for every subsequent cell. There's gotta be a way to access the cell row/col information about a cell and use that in a function. I just can't seem to find the magic google keywords. Thanks.