I have a script which assembles a txt file with some data. This is then appended to a Calc sheet. Most of the data will be raw numbers but from time to time I need to include some simple formula which will also be pasted into Calc and will need to work. It would be something like this:
This would be easy to do if I only knew what would be the location of the cell containing “7” once the data is pasted to Calc… which I don’t… Is there a way to include a formula which does not use any address (e.g =A3/2) but rather a relative address from the current cell (e.g =1_cell_above/2)?