https://bugs.documentfoundation.org/show_bug.cgi?id=158104
Bug ID: 158104
Summary: copy and paste formulas in a table is broken
Product: LibreOffice
Version: 7.6.2.1 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
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).
--
You are receiving this mail because:
You are the assignee for the bug.
