Bug 158674

Summary: Pasting formulas in Writer tables does not dynamically adjust cell references
Product: LibreOffice Reporter: William Friedman <will.friedman>
Component: WriterAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal CC: xiscofauli
Priority: medium    
Version: 7.6.2.1 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description William Friedman 2023-12-12 22:32:03 UTC 
Description:
Copying and pasting formulas from a cell in a Writer table to other cells does not adjust the cell references accordingly, as it does in Calc and, apparently, in AOO (see the fourth comment here: https://forum.openoffice.org/en/forum/viewtopic.php?t=110041).

Steps to Reproduce:
1. Create a 3x3 table.
2. Enter numbers in cells A1, B1, A2, B2, A3, and B3.
3. In C1, enter the formula =<A1>+<B1>.
4. Select the entire cell C1.
5. Copy that cell.
6. Select cells C2 and C3.
7. Paste.

Actual Results:
The formula =<A1>+<B1> is pasted into cells C2 and C3.

Expected Results:
The formula in cell C2 should be =<A2>+<B2> and in cell C3 should be =<A3>+<B3>.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
Comment 1 Xisco Faulí 2023-12-15 07:48:56 UTC 
This looks like a duplicate of bug 157132.
Please update your Libreoffice version to the latest 7.6.4.1

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