Bug 158104

Summary: copy and paste formulas in a table is broken
Product: LibreOffice Reporter: freeware
Component: WriterAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal CC: stephane.guillou
Priority: medium    
Version: 7.6.2.1 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: screen capture

Description freeware 2023-11-07 17:11:56 UTC
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).
Comment 1 freeware 2023-11-07 17:13:17 UTC
Created attachment 190704 [details]
screen capture
Comment 2 Stéphane Guillou (stragu) 2023-11-07 18:17:52 UTC
Thank you for the report. This is already tracked in bug 157132 and should be fixed in the upcoming release 7.6.3.
Please feel free to test a daily build of the upcoming release to confirm it is resolved: https://dev-builds.libreoffice.org/daily/libreoffice-7-6/Win-x86_64@tb77-TDF/2023-11-02_08.41.13/

*** This bug has been marked as a duplicate of bug 157132 ***