Description:
Before in Writer version 7.2.4.2 you could create simple formulas in a table cell and copy and paste that cell to another cell and the addressing of the source cells used to calculate the formula would adapt in relation to the new location.

In Writer version 7.6.2.1 however this is apparently no longer possible, because no matter what previously viable method of copy and paste you use, you always end up replicating the exact LITERAL formula you copied - as if all the addressing in that formula had been set absolute.

I attatched video presentation.

This is such a nuisance and a clear regression. Please fix this ASAP. 

As of now I had to revert back to 7.2.4.2.

Thank you.

Steps to Reproduce:
1. Create new Writer document, add a 2 rows by 3 columns table.
2. Fill in number values as such: A1 = 1, B1 = 10, A2 = 2, B2 = 20.
3. In C1 put a formula - hit = then write sum(<A1:B1>) and hit enter.
4. Use any method to copy cell C1 and paste it into C2.

Actual Results:
Sum value in C2 equals 11 and the formula in C2 reads SUM(<A1:B1>)

Expected Results:
Sum value in C2 equals 22 and formula reads SUM(<A2:B2>).


Reproducible: Always


User Profile Reset: Yes

Additional Info:
This behavior wasn't present in earlier versions (ie. 7.2.4.2).