I have two rows with values and third row must be a difference between first and second row, like here:
3 5 1 . .
2 2 5 . .
1 3 -4 . .
I enter a formula in the 3rd row 2nd column: =$B3-$B4
I enter a formula in the 3rd row 3rd column: =$C3-$C4
And then I (as used in MS excel) select 2 and 3 columns in 3rd row and grab the dot in the bottom right corner, then i pulling it to the right to extend for some columns.
As a result I want to see =$D3-$D4 and =$E3-$E4
But I see only repeating =$B3-$B4, =$C3-$C4, =$B3-$B4, =$C3-$C4, =$B3-$B4, =$C3-$C4.
Tried this in LibreOffice Calc and Gnumeric.
tag libreoffice-220.127.116.11, Ubuntu package 1:3.3.4-0ubuntu1
Well, In your question some parts are not clear. But the result is important. So I will give you the answer.
Now in Libre office calc (or in anyother spread sheet program),if you want to get the result in 3rd row by subtracting from first and second row,your formula doesn't work
so if you want the subtracted result in 3rd row you have to type in 3rd row first column =A1-A2
in 3rd row second column =B1-B2
then inorder to move thse formula to the next part of the third row, selct the 3rd row second column,then grab the dot then drag it to the other are of the third column where you want th formula applicble.
There you have it..... you will get
third row must be a difference between first and second row
All the best from RJK